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.


    FpSpread1.Sheets(0).SaveTextFile("C:\kirk.csv", False, FarPoint.Win.Spread.Model.IncludeHeaders.None, ControlChars.NewLine, ",", ControlChars.Quote)


    Example Output from Line above:


    7,172.26.80.182,Barlett,STAR,CTORE,TEN
    30,172.18.80.208,Hahnemann,PBAR,HAN,TEN


    Desired Output


    "7","172.26.80.182","Barlett","STAR","CTORE","TEN"
    "30","172.18.80.208","Hahnemann","PBAR","HAN","TEN"


     Can this be done



  • 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