Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Jun 06, 2024 6:25 pm

Example code i am trying c#

temppc = "=\""+ i.ProductCode+"\"";
workSheet.Range[row, 3].Text = temppc; //tried Value too same result

For a cell i am trying to get this as text ="xxxxxxxx"

however the spreadsheet will have "=""01896""" and will save that to a csv file.

workSheet.SaveToFile(itemFileName, separator);
Last edited by terfossna on Fri Jun 07, 2024 1:51 pm, edited 1 time in total.

terfossna
 
Posts: 1
Joined: Fri Feb 17, 2023 6:09 pm

Fri Jun 07, 2024 7:29 am

Hello,

Thanks for your inquiry.
Sorry, we don't quite understand the issue you described. Please provide us with your test documentation and complete test code to help us further investigate, and also provide us with some screenshots to describe your issue. You can attach them to the attachment or send them to this email: support@e-iceblue.com. Thank you in advance.

Sincerely,
William
E-iceblue support team
User avatar

William.Zhang
 
Posts: 454
Joined: Mon Dec 27, 2021 2:23 am

Return to Spire.XLS