Format Excel column as percent

Technical support for Spire.DataExport

Moderators: iceblue support, DataExport, Manager

Format Excel column as percent

Postby rdevivo » 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?
rdevivo
 
Posts: 1
Joined: Tue Feb 21, 2012 6:48 pm

Re: Format Excel column as percent

Postby nancy » 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.
Attachments
SALESSUPPORT-559.7z
demo
(44.14 KiB) Downloaded 349 times
Nancy
e-iceblue support team
contact: nancy.wang@e-iceblue.com
User avatar
nancy
 
Posts: 51
Joined: Wed May 30, 2012 2:02 am


Return to Spire.DataExport

Who is online

Users browsing this forum: No registered users and 0 guests