Uderc programming article aggregator sites

Export Datatable to Excel 2010 format and Save in SharePoint Document library ,and whn opening file getting error "WorkBook may be in unsupported file format "

Advertisement
im converting stringwriter objec to Memory stream and saving this as .xlsx uploading file in library ,but when i try to open the file im getting error as below
WorkBook may be in unsupported file format
and when trying to open in excel getting message as
Excel cannot open file  because file extention or file format is not valid .verify thet the file has not been corrupted and file extensions match file format
Advertisement
The best answer: May be you can use this approach:
http://www.c-sharpcorner.com/UploadFile/pandeypradip/export-data-into-excel-in-a-pre-defined-template-using-strea/

Search

Related articles

Extracting a Report from SAP Spool into a Useful Excel 2010 Format

How to reserve the page size when exporting to MS Excel 2010

2146827284Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space

Save output of powershell script to a SharePoint document library?

Excel export (webui crm -- excel) wrong format of house number

Export to MS Excel 2010

Excel 2010 - Can't Save File Becasue It's Opened By Another User

How to add User Permissions to form created in InfoPath 2010 created for SharePoint document Library

Document could not Save after edit in SharePoint Document Library

Unable to add or edit SSRS 2010 subscriptions on reports that need to be saved to specific SharePoint document library

Recommended article

How to Hide or Disable the Edit option of the Sharepoint list from the Ribbon Bar

ESATA card w/ drive connected causes Windows 7 bootup to hang

I have a 6500 officejet printer that says ink system failure what can i do to fix this if anything??

IBooks author font substitution problem

What do I gain by installing more ram ?

Freehand 10 license

HT4623 how about updating an older ipod which does not offer "software update" as a choice when one taps on General under Settings?

QT Pro not downloading from website

I can't install the software from the original DVD

Part of screen blocked