SaveTextFile - Help CSV issue

Posted by: kirkkelly on 8 September 2017, 1:42 pm EST

  • Posted 8 September 2017, 1:42 pm EST


    Using the line below will export the sheet with comma seperating the values,  I need to wrap the values in " " marks also.

    <FONT size=2>

    FpSpread1.Sheets(0).SaveTextFile(</FONT><FONT color=#a31515 size=2><FONT color=#a31515 size=2>"C:\kirk.csv"</FONT></FONT><FONT size=2>, </FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>False</FONT></FONT><FONT size=2>, FarPoint.Win.Spread.Model.IncludeHeaders.None, ControlChars.NewLine, </FONT><FONT color=#a31515 size=2><FONT color=#a31515 size=2>","</FONT></FONT><FONT size=2>, ControlChars.Quote)</FONT>

    <FONT size=2>Example Output from Line above:</FONT>

    <FONT size=2>7,,Barlett,STAR,CTORE,TEN

    <FONT size=2>Desired Output</FONT>

    <FONT size=2>"7","","Barlett","STAR","CTORE","TEN"

    <FONT size=2> Can this be done</FONT><FONT size=2>

  • Replied 8 September 2017, 1:42 pm EST

    They are looking at adding a way to force cell delimiters in a future version.
  • Replied 8 September 2017, 1:42 pm EST

    Thanks for the info.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels