Unsupported FeaturesThere are some features in your workbook that we can't show in the browser

Hi,


I am getting this error if i create excel document using aspose and trying to open in excel web app.

//Enabled license
asposeLicense = new AsposeLicense();
asposeLicense.SetLicense(AsposeLic.Cells); /
Workbook workBook = new Workbook();
workBook.Save(memoryStream, Aspose.Cells.SaveFormat.Xlsx);

I want to know which feature is added to workbook because this warning message is displaying before open in webapp.


Regards.
Sat

Hi,


Well, I am not entirely sure about your issue. Please make sure that MS Excel (2007/2010 ) is installed on your machine so the generated file should be opened fine in your web project.

I used the following sample code and it works absolutely fine. I just create a blank workbook (after setting the valid license for Aspose.Cells). The output file is opened fine in MS Excel, you may find it attached and confirm on your end by opening it into Ms Excel.
e.g
Sample code:

Aspose.Cells.License license = new Aspose.Cells.License();
license.SetLicense(@“E:\Licenses\18-12-2013 Aspose.Total\Aspose.Total.lic”);

var workbook = new Workbook();
var stream = new MemoryStream();
workbook.Save(stream, SaveFormat.Xlsx);

string filename = “e:\test2\outtestin1.xlsx”;

FileStream fstream = new System.IO.FileStream(filename, FileMode.OpenOrCreate);
byte[] data = stream.ToArray();
fstream.Write(data, 0, data.Length);

If you still find any issue, kindly do create a sample project (runnable) and post it here (do not attach your license file with your project archive) to reproduce the issue on our end. We will check your issue soon.

Thank you.

hi Amjad Sahi,


Thanx for quick response. The sample code which i have sent to you , is working fine in standalone application(let say console based app).

But my requirement is that we are creating excel document and on the fly we are displaying into web browser(Its web based application). For this we are using webAPI concept.
I am using the following code for creating the excel doc.
asposeLicense = new AsposeLicense();
asposeLicense.SetLicense(AsposeLic.Cells);
Workbook workBook = new Workbook();
workBook.FileFormat = FileFormatType.Xlsx;
workBook.RemoveExternalLinks();
workBook.Protect(Aspose.Cells.ProtectionType.None,null);
workBook.Save(memoryStream, Aspose.Cells.SaveFormat.Xlsx);

File(Error.png) is attached for your reference.

Hi,


Could you replace the last line i.e.,:
workBook.Save(memoryStream, Aspose.Cells.SaveFormat.Xlsx);

with (e.g):
//Save in xlsx format and send the file to user so that he may open the file in
//some application or save it to some location
workBook.Save(this.Response, “Report.xlsx”, ContentDisposition.Attachment, new OoxmlSaveOptions());
Response.End();

If you still find the issue, kindly create a sample web application (runnable) with Aspose.Cells for .NET v7.7.0, zip it and post it here to show the issue, we will check your issue soon.

Also, give us details which MS Excel version you have installed on your machine.

Thank you.