Problems with trial version 4.5

Aspose.Cells Product Family
1

Hi

I’m trying to use Aspoce.Cells in our project for combining several excel reports on server side. But stops on very first step. After loading existing Excel workbook with Aspose and saving it back on disk, resulting file lost all data and breaks the formating. But have nice sheet with evalution warning. I’m attach original file and result workbook after processing by aspose. Just three lines of code

Workbook book = new Workbook();
book.LoadData(reportNames[0]);
book.Save(reportNames[0],FileFormatType.Excel2003);

Where i’m wrong?

Thank for advice
Stas


P.S. forgot to say, .NET 2.0 is used

2

Hi Stats,

Please use Workbook.Open() method instead of LoadData() method.

You may try to change your code to:

Workbook book = new Workbook();
book.Open(reportNames[0]);
book.Save(reportNames[0],FileFormatType.Excel2003);

For your info, LoadData only loads data as some formattings, objects would be lost.

For complete reference, please scan throught the documentation in different sections: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/index.html

Thank you.

3

Amjad

Thank for the info. It is work with Open. As always, if nothing are work probably it’s time to read documentation :slight_smile:

Stas