To Export Excel to .xlsb format

Question

0.00/5 (No votes)

See more:

C#

ASP.NET

Please any suggest to export the data through c# to excel and need to save that file Excel binary format(as .xlsb).

Posted 21-Jan-15 2:03am

Velu04

Add a Solution

Comments

CHill60 21-Jan-15 8:28am

What have you tried? Can you export to Excel xls format?

Velu04 21-Jan-15 23:19pm

Hi, i need to export details to Excel xlsb format. We have already doing export in Excel xls format. Due to large file size we planned to export to excel xlsb format.

CHill60 22-Jan-15 5:24am

If you use Workbook.SaveAs when exporting to xls try using XlFileFormat.xlExcel12 as the format (2nd parameter to the SaveAs)

[no name] 21-Jan-15 9:45am

If you want to export a excel from a grid view then the below code snippet can help you.I am not really sure on .xlsb format,but this works well with.xls.

HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName + ".xls"));
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = "application/ms-excel";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
gv.RenderControl(htmlWrite);//gv is the gridview
HttpContext.Current.Response.Write(stringWrite.ToString());
HttpContext.Current.Response.End();

Velu04 21-Jan-15 23:24pm

Hi mishra,

I checked in this way also. The file with xlsb saved but not able to open the following file. It shoes the error as " Excel cannot open the file "Testxlsb" because the file format or file extension is not valid".

Please support if any this wrong with me.

[no name] 22-Jan-15 9:14am

In this case you have to clear your appdata folder.
Fore more information please visit the following URL and check the answers.
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-canot-open-the-file-personalxlsb-because-the/a515bbe3-a0d1-49de-a51b-f5c92da082cc

Velu04 23-Jan-15 1:33am

Hi,

I can't find the following path in my computer :

C:\Program Files\Microsoft Office\Office14\XLStart (C:\Program Files (x86)\Microsoft Office\Office14\XLStart in case of 64-bit O/S).

I also checked C:\Program Files (x86)\Microsoft Office\Office12\XLStart. There is no excel files found there

[no name] 22-Jan-15 9:18am

If above one will not work out then i can suggest you to go for addins and check in trust center if your excel autostart is pointing to actual folder.

Member 13697316 14-Jun-19 9:25am

I also checked. There is no files. Any alternate solution on this issue.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)