Roadkil.Net


Forums > XLS2CSV	Search Log In

Author

Message

major4579
Joined: 7 Jan 2009
usa

Posted: 7 Jan 2009

I tried this program but it would not convert any of the numbers.

Here are the first few lines when I use Excel 2003 to save the spreadsheet as a CSV file:

CustomerName,Specie,ShipDate,Pallet no.,LogyardTag,Flitch,LabelLength,SquareMeters,SquareFeet,Lot,Bundles,Bundle,Sheets,Length,Width,BundleLength,BundleWidth,Bundle Sqmt,Bundle Sqft TEST.,Maple,2/14/07 0:00,1,C36017,0,2.9,427.22,4599,YV0531,60,1,0,280,32,280,32,0,0 TEST.,Maple,2/14/07 0:00,1,C36017,0,2.9,427.22,4599,YV0531,60,2,0,280,27,280,27,0,0 TEST.,Maple,2/14/07 0:00,1,C36017,0,2.9,427.22,4599,YV0531,60,3,10,90,29,90,29,2.61,28

And here are the same lines when I convert the same files use XLS2CSV:

"CustomerName","Specie","ShipDate","Pallet no.","LogyardTag","Flitch","LabelLength","SquareMeters","SquareFeet","Lot","Bundles","Bundle","Sheets","Length","Width","BundleLength","BundleWidth","Bundle Sqmt","Bundle Sqft" "TEST.","Maple",,,"C36017",,,,,"YV0531" "TEST.","Maple",,,"C36017",,,,,"YV0531" "TEST.","Maple",,,"C36017",,,,,"YV0531"

Let me know if you'd like the xls file itself. -John

Roadkil
Joined: 28 Mar 2008
South Australia

Posted: 12 Jan 2009

Very strange - the XLS file stores differnt formatted columns in a differnet way.. ther emust be a formatting option the XLS2CSV doesnt cover. If you could send me the XLS file (or just the first line or two) I can look into it further!

Hydaral
Joined: 29 Sep 2009
Perth, Australia

Posted: 1 Feb 2010

I've just noticed this problem, I did a bit of testing:

XLS2CSV will only convert numbers if the cell has been formatted as text AND the number has been re-input into the cell (so it has the green triangle in the corner of the cell), either by re-typing or copy and paste. Formulas and text both work fine.

Page: 1

You must log in to reply to messages