File not saving in MS2007 version

Aspose.Cells Product Family
1

I am exporting my data in MS2003 and MS2007 version, but same code is running for exporting the data in
MS2003 and MS2007 version only save format I am changing.


Problem which I am facing is for MS2003 file has been saved but for MS2007 file has not been saved even no exception has been occurred.

On my server MS 2000 has been installed, as I know Aspose read and write Excel spreadsheets without utilizing Microsoft Excel.
which is mentioned at below link


Can anybody help me, how to resolve this problem.

Regards
Animesh
2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Aspose.Cells for .NET does not require the Ms-Excel to be installed on your computer.

Could you provide your sample code replicating this problem? Please also provide any source xls/xlsx file you are using inside your code.

Please also download and use the latest version:
Aspose.Cells
for .NET v7.2.2.3
and let us know your feedback.

Below is a sample code to save the workbook into xls and xlsx format.

C#


workbook.Save(“output.xls”, SaveFormat.Excel97To2003);

workbook.Save(“output.xlsx”, SaveFormat.Xlsx);



3

Hi,


I am using Aspose.Cells version 7.0.0.0 and I am using smartmarkers for it.

Same code is running for saving the file in MS2003 and MS2007 but it is not saving in MS2007 version.

On the server MS2000 is installed.

Can anybody help me what can be the reason.


switch (versionType)
{
case VersionType.Ms2003:
workbookDesigner.Workbook.Save(string.Concat(fileName, “.”, XlsFormatType), SaveFormat.Excel97To2003);
url = String.Concat(fileUrl, “.”, XlsFormatType);
break;
case VersionType.Ms2007:
case VersionType.Ms2010:
workbookDesigner.Workbook.Save(string.Concat(fileName, “.”, XlsxFormatType), SaveFormat.Xlsx);
url = String.Concat(fileUrl, “.”, XlsxFormatType);
break;
}


Regards
Animesh
4

Hi Animesh,


Please note, although Aspose.Cells does not use or even depend on MS Excel Automation / APIs, it does not require MS Excel to be installed either on the server or client system. But, one thing should be cleared here, if you need to view the generated file or want to save the file on the fly (in an ASP.NET web project etc.), you must have at least MS Excel Viewer ( for 2007/2010) or MS Excel 2007/2010 installed on the client end to view the XLSX files generated by your code (Aspose.Cells APIs).

If you still have any issue/problem or something else, let us know with all the details and files. Also, create a sample project, zip it and post it here to reproduce the issue on our end. Also, provide us the sample Excel files(e.g XLSX) here. We will check your issue soon.

Thank you.

5

Hi
Amjad,


Please correct me if my understanding is wrong, we need at least MS2007 viewer on the server where we are generating the file and saving it.

On my client machine I have MS2010.

Waiting for your response.

Regards
Animesh
6

Hi,


You should have MS Excel Viewer 2007/2010 or MS Excel 2007/2010 installed on the system where you want to view the generated file on the fly.

Since you have already installed MS Excel/Office 2010, so there should be no problem for viewing the Excel files (XLSX file format).

I suspect there might be an issue with your code. So, kindly create a sample runnable project, zip it and post it here to show the issue. Also, attach your Excel file(s) (source and output etc.). We will check your issue soon.

Thank you.
7

Hi Amjad,


The problem is, on server where I have MS2003/2007/2010, the same code is working but the server where I have MS 2000 code is not saving the file and no exception is coming up.

Is that any other server configuration or any IIS setting is required for this.

Waiting for your response.

Regards
Animesh Raj
8

Hi,

Please try running your application in Full Trust permission sets and see if you get any different results.

Generally, all Aspose .NET components require Full Trust permissions set. The reason is, Aspose .NET components need to access registry settings, system files other than virtual directory for certain operations like parsing fonts etc. Moreover, Aspose .NET Components (including Aspose.Cells for .NET) are based on core .NET system classes that also require Full Trust permissions set in many cases.