Sheet.SaveTofile - Double quotes

[Greenlynx]

Hello,

I want to export a huge excel worksheet to a text file.

I'm using the following command :

Code: Select all

worksheet.SaveToFile(destination & "\" & "prices.txt", vbTab, encoder)

This is working however Spire is adding double quotes aroud every string of the file.

Is there a way to simply obtain raw data without those quotes ?

Thanks for your help on this.

Regards,

G

[caroline.zhang]

Hi G,

Thank you for inquiry.
Sorry that at present our product doesn't support the feature. I recommend you to save the text and then remove these double quotes from the text file.

Sincerely,
Caroline
E-iceblue support team

[gauti0710]

Hi,

Can we remove double quotes after converting to CSV in a existing code?

Workbook workbook = new Workbook();

workbook.LoadFromFile(sourceFile.FullName);

Worksheet sheet = workbook.Worksheets[0];

//Worksheet worksheet = workbook.Worksheets[0]; sheet.InsertColumn(1);

sheet.SaveToFile(sourceFile.FullName.Replace(".xls", ".csv"), "|", Encoding.ASCII);


if yes then how?

Please reply

[gauti0710]

DO you have any answer for this?

[lynn.zhang]

Hi,

Thanks for your post.
What you want is to remove all double quotes in the csv file generated after conversion, as shown in the following figure right? If so, we are sorry that our Spire.Xls does not have a direct way to achieve it.

Sincerely,
Lynn
E-iceblue support team

[gauti0710]

Oh Ok thanks for confirming

[lynn.zhang]

Hi,

Thanks for your reply.
If you encounter any issues related to our products in the future, just feel free to contact us. Wish you all the best!

Sincerely,
Lynn
E-iceblue support team