Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving file in CSV format
I am facing a problem while saving a CSV file from Excel. The problem is as follows: I have a CSV file with 1st row having 20 columns and the rest of the rows having data in first 16 columns and next four columns are empty. So when I am creating a CSV file in notepad/textpad, the last 4 columns are represented by 4 commas (','). Then I am opening the CSV file in excel and using the save as option, I am saving it with a new name. The new file when opened in textpad/notepad, the 4 commas are appearing only till first 16 rows. from 17th row onwards, the trailing 4 commas are not appearing. I need those commas since they represent empty columns. otherwise the program which is accepting the csv file will generate error. I am attaching the original CSV file and the CSV file saved using excel for your reference. Please help. Thanks in advance -- meeta das ------------------------------------------------------------------------ meeta das's Profile: http://www.excelforum.com/member.php...o&userid=31559 View this thread: http://www.excelforum.com/showthread...hreadid=512540 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving file in CSV format
Strange. It surely has ALL the delimiters when I test it here.
But it also has ONLY the rows that contain data and no additional rows. What's in the extra rows? Hans |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving file in CSV format
Saved from a previous post:
This might describe the problem of too many commas in CSV files: http://support.microsoft.com/default.aspx?scid=77295 Column Delimiters Missing in Spreadsheet Saved as Text (It actually describes missing delimiter, but if some are "missing", maybe the ones appearing are "extra".) (But a lot of programs (excel included) don't care about those extra columns. Maybe you don't have to care, either???) Maybe you could write your own exporting program that would behave exactly the way you want: Here are three sites that you could steal some code from: Earl Kiosterud's Text Write program: www.smokeylake.com/excel (or directly: http://www.smokeylake.com/excel/text_write_program.htm) Chip Pearson's: http://www.cpearson.com/excel/imptext.htm J.E. McGimpsey's: http://www.mcgimpsey.com/excel/textfiles.html (or maybe you could build your own formula and copy|paste into Notepad.) meeta das wrote: I am facing a problem while saving a CSV file from Excel. The problem is as follows: I have a CSV file with 1st row having 20 columns and the rest of the rows having data in first 16 columns and next four columns are empty. So when I am creating a CSV file in notepad/textpad, the last 4 columns are represented by 4 commas (','). Then I am opening the CSV file in excel and using the save as option, I am saving it with a new name. The new file when opened in textpad/notepad, the 4 commas are appearing only till first 16 rows. from 17th row onwards, the trailing 4 commas are not appearing. I need those commas since they represent empty columns. otherwise the program which is accepting the csv file will generate error. I am attaching the original CSV file and the CSV file saved using excel for your reference. Please help. Thanks in advance -- meeta das ------------------------------------------------------------------------ meeta das's Profile: http://www.excelforum.com/member.php...o&userid=31559 View this thread: http://www.excelforum.com/showthread...hreadid=512540 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Automatic File Saving | Excel Discussion (Misc queries) | |||
Excel getting Error - file format is not valid WHEN OPENING | Excel Discussion (Misc queries) | |||
file format is not valid? | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |