October 16, 2011 at 1:31 am
I have made a package where in I am exporting the SQL data to a Excel. The excel data have a fixed template. I am using the custom format for some particular columns where in I want the digits to be prefixed with a '$' sign and also ',' separated.To do this I have made a cell with the required custom format and below that cell all the required data is copied from SQL.
Problem :- But the problem I am facing is that the digits after decimal are getting rounded off to 4 digits
Analysis :- a) There is no problem with the custom format as on using the same custom format outside on another excel it is working fine
b) There is no problem with the data which is being transferred to excel as when I am exporting the data without the custom formatted it is copying the digits with all the digits after decimal.
Please let me know what can be done on this...
October 17, 2011 at 2:53 am
I haven't tried to use currency, but I have found that for many number related items, I have to import the items as an append into a worksheet that has a dummy record with all the correct formats. On the worksheet on which I want the information to appear, I have to reference that information starting from the row after the dummy row.
It's not elegant, but others have written of a similar work around. Hopefully someone considers this a shortcoming and will work to fix it for a future version.
October 17, 2011 at 9:55 am
Yeap, exactly what Ron suggested. Excel destinations are notoriously bad for misinterpreting what you're trying to feed in to them. Having a dummy row lets the system figure out what you want to go into where.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy