Start Building Professional
Web Apps Today

export to csv

When I use the serializeToCSV the values are correctly exported but there seems to be extra values which I assume are the grid configuration settings needed to reload the csv into the grid. How can I suppress those values from csv?

There is no possibility to put grid configuration values to the CSV format. This is limitation of the CSV format.

Actually, I realized that the extra values are not extra values at all.  The extra columns are coming from the incorrect export of cell values.  For example, the cell value of 1,000,000 exported to CSV using the comma (,) delimeter becomes three distinct values '1', '000', and '000'.  How can either remove the thousands seperator from the values prior to export or get the export to ignore the column formatting?

You can change CSV delimiter using method:
setCSVDelimiter(str) where str - delimer used in CSV operations  (only single char delimeters allowed)

I found a workaround.  What I'm doing is using a non-standard delimeter tilde (~) then I replace all commas in the resulting csv data with blanks, then I replace all tildes with commas and voila, problem solved.  Thanks anyway.