| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extra trailing commas in exported CSV
Hi All I have some VBA that exports a sheet from my workbook as a CSV file. I do some cleaning up on the sheet before it is exported: wksCSV.Range("H2:AA65536").Clear wksCSV.Range("A2:AA65536").ClearFormats Despite this I consistently get two extra trailing commas on rows 2 to 16 (first row is a header, which is longer) in the resulting CSV (as if H2:I16 contained something). Any suggestions? -- lucidr ------------------------------------------------------------------------ lucidr's Profile: http://www.excelforum.com/member.php...o&userid=36699 View this thread: http://www.excelforum.com/showthread...hreadid=564635 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extra trailing commas in exported CSV
You will get as many comma's as columns The number of columns is set by the header row -- Kaak ------------------------------------------------------------------------ Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513 View this thread: http://www.excelforum.com/showthread...hreadid=564635 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extra trailing commas in exported CSV
This doesn't happen for rows beyond row 16. Does Excel do this in chunks of 16 rows maybe? Another great bit of 'design'... -- lucidr ------------------------------------------------------------------------ lucidr's Profile: http://www.excelforum.com/member.php...o&userid=36699 View this thread: http://www.excelforum.com/showthread...hreadid=564635 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extra trailing commas in exported CSV
Very good!
lucidr wrote: This doesn't happen for rows beyond row 16. Does Excel do this in chunks of 16 rows maybe? Another great bit of 'design'... -- lucidr ------------------------------------------------------------------------ lucidr's Profile: http://www.excelforum.com/member.php...o&userid=36699 View this thread: http://www.excelforum.com/showthread...hreadid=564635 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extra trailing commas in exported CSV
You have another response at your original thread.
lucidr wrote: Hi All I have some VBA that exports a sheet from my workbook as a CSV file. I do some cleaning up on the sheet before it is exported: wksCSV.Range("H2:AA65536").Clear wksCSV.Range("A2:AA65536").ClearFormats Despite this I consistently get two extra trailing commas on rows 2 to 16 (first row is a header, which is longer) in the resulting CSV (as if H2:I16 contained something). Any suggestions? -- lucidr ------------------------------------------------------------------------ lucidr's Profile: http://www.excelforum.com/member.php...o&userid=36699 View this thread: http://www.excelforum.com/showthread...hreadid=564635 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save as CSV: extra spaces around commas | Excel Discussion (Misc queries) | |||
| trailing spaces | Excel Worksheet Functions | |||
| An XML mapping cannot be exported | New Users to Excel | |||
| Extra characters exported in unicode(.txt) format | Excel Discussion (Misc queries) | |||
| Trailing Stop | Excel Discussion (Misc queries) | |||
![lucidr[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
