Spire.DataExport for .NET is a 100% pure data .NET library suit for exporting data into MS Word, Excel, RTF, Access, PDF, XPS, HTML, XML, Text, CSV, DBF, SYLK, SQL Script, DIF, Clipboard, etc.

Fri Jun 08, 2012 9:20 pm

I have successfully formatted my Excel columns as dates or currency using the GetDataParams event, but I can't figure out how to format a column as a percent (i.e., multiply by 100 and add % symbol). I don't want to format the column as text since I want to retain the underlying number for calculations.

Is there any FormatText string I can use to achieve this?

Posts: 1
Joined: Tue Feb 21, 2012 6:48 pm

Mon Jul 02, 2012 9:00 am

Hi rdevivo,

About your problem, I have writed a demo in the attachment. You can refer to it. Thank you for your cooperation and understanding.
(44.14 KiB) Downloaded 927 times
e-iceblue support team
contact: nancy.wang@e-iceblue.com
User avatar

Posts: 51
Joined: Wed May 30, 2012 2:02 am

Return to Spire.DataExport