I have a customer requirement to apply specific formatting to existing Excel-based reports. The formatting would include things like:
changing / setting background colour for cells
changing datatypes of cells eg. from string to numeric
setting column width to auto-fit
adding summary information to foot of workbook based on information in report
setting Page Setup values eg. changing page setup from portrait to landscape and setting, or changing scaling to fit to 1 page
adding / editing header or footer information
There are some other requirements too but these are the most important ones I’ll need to do.
Can Aspose.Excel do these things on a given workbook?
Also, as I’m planning on using a web interface for users to upload the report that needs formatting, will I need Aspose.Excel or AsposeExcel.Web? What’s the difference?