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,172.26.80.182,Barlett,STAR,CTORE,TEN
    30,172.18.80.208,Hahnemann,PBAR,HAN,TEN
    </FONT>


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


    <FONT size=2>"7","172.26.80.182","Barlett","STAR","CTORE","TEN"
    "30","172.18.80.208","Hahnemann","PBAR","HAN","TEN"</FONT>


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



    </FONT>
  • 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