Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
All columns not being recognized in .csv file.
I have an .xls spreadsheet with 34 columns, all of which may or may not
include data. Data is entered on each line, but each line contains many blank cells. When I save the file as a .csv file, all the columns are not recognized. When viewed in notepad, some lines contain 28 commas; others have the 34. If I import this file into my application, it returns many errors for wrong number of columns. Has anyone run into this problem and found a solution? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
All columns not being recognized in .csv file.
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.) Decision Assist wrote: I have an .xls spreadsheet with 34 columns, all of which may or may not include data. Data is entered on each line, but each line contains many blank cells. When I save the file as a .csv file, all the columns are not recognized. When viewed in notepad, some lines contain 28 commas; others have the 34. If I import this file into my application, it returns many errors for wrong number of columns. Has anyone run into this problem and found a solution? Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
All columns not being recognized in .csv file.
Thanks, Dave. I may have to go this route. I do need the exact number of
columns for my upload, regardless of the cell content. If I put a space in each empty cell, then it recognizes the column. Unfortunately, that's not a solution. I have too many empty cells, and it would mess up my upload. Thanks for the tip. I'll look into it. Have a good day. Patricia "Decision Assist" wrote: I have an .xls spreadsheet with 34 columns, all of which may or may not include data. Data is entered on each line, but each line contains many blank cells. When I save the file as a .csv file, all the columns are not recognized. When viewed in notepad, some lines contain 28 commas; others have the 34. If I import this file into my application, it returns many errors for wrong number of columns. Has anyone run into this problem and found a solution? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
All columns not being recognized in .csv file.
Are the cells "blank" or Empty?
when I try with empty cells I get no comma, when I enter a single space in them I get a comma, when I format them as Text I get a comma, even if there is nothing in them. "Decision Assist" wrote in message ... I have an .xls spreadsheet with 34 columns, all of which may or may not include data. Data is entered on each line, but each line contains many blank cells. When I save the file as a .csv file, all the columns are not recognized. When viewed in notepad, some lines contain 28 commas; others have the 34. If I import this file into my application, it returns many errors for wrong number of columns. Has anyone run into this problem and found a solution? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make sure all empty columns are present in a .csv file? | Excel Worksheet Functions | |||
saving .csv formated file | Excel Discussion (Misc queries) | |||
.csv drops "0" when saved, even if file was set as "text". | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Openning an .csv file | Excel Discussion (Misc queries) |