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
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?