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.

Tue Feb 03, 2015 1:54 pm

RIT.zip
Hello,
I have a problem in editing an Excel file. After I have edited the file using the following code:
Code: Select all
Workbook wb = new Workbook();
wb.LoadFromFile(newTemp.FullName);
Worksheet sheet = wb.Worksheets[0];
sheet.Range["L1"].Text = "test";
wb.SaveToHttpResponse(newTemp.FullName, Response);


The image in the file disappears.

bluezeus
 
Posts: 4
Joined: Tue Feb 03, 2015 1:05 am

Wed Feb 04, 2015 1:34 am

Hello bluezeus,

Thanks for your inquiry.

After testing your document with Spire.Xls v7.6.21, I can see that the image file displays correctly in the generated file, please download it and have a try:
http://www.e-iceblue.com/Download/downl ... t-now.html
Best Regards,
Burning
E-iceblue Support Team
User avatar

burning.liu
 
Posts: 406
Joined: Mon Aug 04, 2014 6:47 am

Wed Feb 04, 2015 10:22 am

Thanks for your reply.

I use FreeSPire.XLS v. 7.4, could this be the problem?
If yes, how can I solve the problem using this version?

bluezeus
 
Posts: 4
Joined: Tue Feb 03, 2015 1:05 am

Thu Feb 05, 2015 1:52 am

Hello bluezeus,

I used Free Spire.Xls v7.4 to test the sample document, the image displayed in the generated excel file.

So can you provide us following information to help us reproduce this problem? Thank you.

---System Information
---Programming Environment (Visual Studio Version)
---Sample Project
Best Regards,
Burning
E-iceblue Support Team
User avatar

burning.liu
 
Posts: 406
Joined: Mon Aug 04, 2014 6:47 am

Thu Feb 05, 2015 10:21 am

The image that disappears is the logo.
It does not insert through code but is already present in the file to edit.

bluezeus
 
Posts: 4
Joined: Tue Feb 03, 2015 1:05 am

Fri Feb 06, 2015 1:51 am

Hello bluezeus,

Sorry that I cannot reproduce this problem.

I upload my testing project and the generated excel file, please check that.
Attachments
4365.zip
(63.47 KiB) Downloaded 240 times
Best Regards,
Burning
E-iceblue Support Team
User avatar

burning.liu
 
Posts: 406
Joined: Mon Aug 04, 2014 6:47 am

Tue Feb 10, 2015 9:28 am

Thanks for your reply.

In the end I opted to use oledb, given the urgency.

bluezeus
 
Posts: 4
Joined: Tue Feb 03, 2015 1:05 am

Tue Feb 10, 2015 9:35 am

Hello,

Please feel free to contact us if you have any questions.
Best Regards,
Burning
E-iceblue Support Team
User avatar

burning.liu
 
Posts: 406
Joined: Mon Aug 04, 2014 6:47 am

Return to Spire.XLS