I am trying to create excel sheet with multiple tabs using visulaforce page

Question

I am trying to create excel sheet with multiple tabs using visulaforce page . I am facing some issues in formating number for example below cell is having number formate with comma separated but when I look @ out put excel sheet the number is not with comma 1,76,213 680 465 4,756 4,566 4,35,353 567 4,564 26,752 23,015 6 4,56,6 Out put, if you look @ below screen i need to put some % and $ and different symbols in the cells . when I ma trying to put those symbols excel sheet is not considering and it is not opening getting file is corrupted and when see the more details is saying one of the cell is having invalid data. any please suggest how to formate a number using apex visualforce. Example will be help full

Aruna Rapole · Accepted Answer

Thank you for your replay I appreciate your help. Sure next time will do post in EXcel XML structure Below is the solution for my question.

Patrick Connelly · Answer

To have this formatted you need to setup number formatting [1] [2].  If you add these to your Visualforce page correctly they should do what you are looking for.  I would suggest that if you have any issues like this in the future that do not pertain directly to Visualforce but instead to how to use the Excel XML structure that you post them to an Excel specific forum since you will most likely get a faster response. [1]  http://wiert.me/2011/08/25/excel-xml-spreadsheet-styles-and-formatting/ [2]  http://stackoverflow.com/questions/17110155/adding-formatting-to-excel-cell

I am trying to create excel sheet with multiple tabs using visulaforce page

Visualforce

Related Learning

More Help