Search results matching tag 'excel'

Re: Import Excel data into SQL db

SergeKor — Sat, 19 Dec 2009 05:00:00 GMT

You can see a good description of importing Excel files here

How to create Excel Cross Tab Report

shak — Fri, 18 Dec 2009 05:00:00 GMT

Hello everyone, I am wandering that how can I create Cross-Tab Report with DataSets and display the data in Microsoft Excel with C#?

'Filename.xls' cannot be accessed. When downloading from Server

stephen.adshead — Thu, 17 Dec 2009 05:00:00 GMT

'Filename.xls' cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.

I have several Excel files which my end users can download from my ASP.net app however this has suddenly stopped working on all the Excel Spreadsheets, when you try and open the file you get the error above.

Is this something that has been changed in the web.config? I have been googling the error but all posts refer to spreadsheet corruption... they cant all have become currupt surely?

Thanks in advance

Steve

External table is not in the expected format.

pritam.ahire — Thu, 17 Dec 2009 05:00:00 GMT

i have developed 2 applications in asp.net which wil b use by 2 persons at diff location .,,,in my first application at the end user genrate excel sheet from gridview which he/she send to second person via mail

the second person receives tht mail and he/she upload tht excel file but while uploading tht excel file i am getting following error

External table is not in the expected format.

after some trial/error method i found tht if i am Re-Saving tht file with some another name

then tht excel file is successfully uploaded ,,i dont knw whts prob

Re: Help me on how to Export datagrid data to Excel?

waqas_w — Tue, 08 Dec 2009 05:00:00 GMT

public static void ConvertDstoExcel(DataSet ds ,HttpResponse response)
    {
    
        response.Clear();
        response.Charset = "";
    
        response.ContentType = "application/vnd.ms-excel";
    
        StringWriter stringWrite = new StringWriter();
        HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        
        DataGrid dg = new DataGrid();
        dg.DataSource = ds.Tables[0];
        dg.DataBind();
    
        dg.RenderControl(htmlWrite);
    
        response.Write(stringWrite.ToString());
        response.End();
    }

hope its helpfull

Generate excel using xml

visitmohanraj — Thu, 03 Dec 2009 05:00:00 GMT

Hi all i want to genrate an excel file using xml.currently i have a string variable which holds xml structure i want to know how can i generate an excel file using xml structre in string variable ?? i have used xmldocument.load( variable) but this give me an error i have attached the code and error for reference?? using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using Excel = Microsoft.Office.Interop.Excel; using System.Xml; using System.IO; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string strExcelXml = string.Empty; //Excel.Application xlApp; //Excel.Workbook xlWorkBook; //Excel.Worksheet xlWorkSheet; //object misValue = System.Reflection.Missing.Value; //xlApp = new Excel.ApplicationClass(); //xlWorkBook = xlApp.Workbooks.Add(misValue); //xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); //xlWorkSheet.Cells[1, 1] = "http://csharp.net-informations.com"; //xlWorkBook.SaveAs("csharp-Excel.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); //xlWorkBook.Close(true, misValue, misValue); //xlApp.Quit(); //releaseObject(xlWorkSheet); //releaseObject(xlWorkBook); //releaseObject(xlApp); //MessageBox.Show("Excel file created , you can find the file c:\\csharp-Excel.xls"); strExcelXml += (ExcelHeader()); // Create First Worksheet strExcelXml += (WriteFirstWorkSheet()); // Worksheet options Required only one time strExcelXml += (ExcelWorkSheetOptions()); for (int i = 1; i "); // Then Table Tag strExcelXml += (""); for (int k = 1; k "); for (int j = 1; j "); } strExcelXml += (""); } strExcelXml += ("

"); strExcelXml += ( "Sheet" + i.ToString() + "Row" + k.ToString() + "Col" + j.ToString()); strExcelXml += ("

"); strExcelXml += (""); } // Close the Workbook tag (in Excel header // you can see the Workbook tag) strExcelXml += ("\n"); XmlDocument empDoc = new XmlDocument(); // Response.ContentType = "text/xml"; //Load the XML from a String empDoc.LoadXml(strExcelXml); //Save the XML data onto a file empDoc.Save("D:\\EmployeesNew.xml"); // Response.Write(empDoc.InnerXml); } private string ExcelHeader() { // Excel header System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("\n"); sb.Append("\n"); sb.Append( "\n"); sb.Append( ""); sb.Append(""); sb.Append( "\n"); sb.Append("False\n"); sb.Append("False\n"); sb.Append("\n"); return sb.ToString(); } private string WriteFirstWorkSheet() { //These tags can be generated by jsut creating an test Excel and Save As "Spreadsheet XML" string strFirstWorkSheet = string.Empty; System.Text.StringBuilder sb = new System.Text.StringBuilder(); // sb+=""; string strNewLine = "\n"; strFirstWorkSheet += "" + strNewLine; strFirstWorkSheet += "" + strNewLine; strFirstWorkSheet += "" + strNewLine; strFirstWorkSheet += "" + strNewLine; // Merge Cells strFirstWorkSheet += "Column Merged" + strNewLine; strFirstWorkSheet += "" + strNewLine; // Bold strFirstWorkSheet += "" + strNewLine; strFirstWorkSheet += "Bold" + strNewLine; strFirstWorkSheet += "" + strNewLine; strFirstWorkSheet += "" + strNewLine; //Italics strFirstWorkSheet += "Italics" + strNewLine; strFirstWorkSheet += "" + strNewLine; strFirstWorkSheet += "" + strNewLine; //Hyperlink strFirstWorkSheet += "Hyperlink" + strNewLine; strFirstWorkSheet += "" + strNewLine; //Row Height strFirstWorkSheet += "" + strNewLine; strFirstWorkSheet += "Row Height" + strNewLine; strFirstWorkSheet += "" + strNewLine; // Close Tags strFirstWorkSheet += "

" + strNewLine; strFirstWorkSheet += "" + strNewLine; return strFirstWorkSheet; } private string ExcelWorkSheetOptions() { // This is Required Only Once , But this has to go after the First Worksheet's First Table System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("\n\n\n \n"); return sb.ToString(); } Error which I am getting when using load document method is:"The generated excel cannot be viewed" i get the xml structure in strExcelXml variale and the xml structure is: False False Column Merged Bold Italics Hyperlink Row Height

Sheet1Row1Col1	Sheet1Row1Col2
Sheet1Row2Col1	Sheet1Row2Col2
Sheet1Row3Col1	Sheet1Row3Col2
Sheet1Row4Col1	Sheet1Row4Col2
Sheet1Row5Col1	Sheet1Row5Col2
Sheet1Row6Col1	Sheet1Row6Col2
Sheet1Row7Col1	Sheet1Row7Col2
Sheet1Row8Col1	Sheet1Row8Col2
Sheet1Row9Col1	Sheet1Row9Col2
Sheet1Row10Col1	Sheet1Row10Col2
Sheet1Row11Col1	Sheet1Row11Col2
Sheet1Row12Col1	Sheet1Row12Col2
Sheet1Row13Col1	Sheet1Row13Col2
Sheet1Row14Col1	Sheet1Row14Col2
Sheet1Row15Col1	Sheet1Row15Col2
Sheet1Row16Col1	Sheet1Row16Col2
Sheet1Row17Col1	Sheet1Row17Col2
Sheet1Row18Col1	Sheet1Row18Col2
Sheet1Row19Col1	Sheet1Row19Col2

so how do i do it and whats wrong in this???

Dynamically generate EXCEL file

sharadc — Mon, 30 Nov 2009 05:00:00 GMT

Hi All,

My requirement is kind of export to excel funtionality from a search page, where the number of columns and rows will be decided on the creteria selected by user. But the basic design of the excel is fixed..... so I was thinking if it is possible to have ready template where all the formatting thing can be predefined and at runtime I can just repeat the rows and coulmn with their respective cell values (If possible would like to add formulas also).

The data has to be pulled from the database so I guess there is no luxury for me to generate excel direcly from DataGrid. But I am ready to try options using HTML/Data Grid/XML/EXCEL (If possible any other option without using Office library because it has lot of dependency on version etc.)

Since the excel will be dynamically generated, immediate reponse is expected.

Looking for your valuable suggestions...

Re: need help: Export large data from table to excel

pritam.ahire — Fri, 27 Nov 2009 05:00:00 GMT

yes u can do this i guess you want to genrate excel sheet from ur table which is stored into ur database

do one thing on drag gridview and button onto page nd on page load event bind ur table to gridview then

on clicking of tht button write following code it will genrate excel sheet for u

using System.IO; namespace

string attachment = "attachment; filename=GridViewExport.xls"

Response.ClearContent();

Response.AddHeader("content-disposition", attachment);

Response.ContentType = "application/ms-excel";

StringWriter sWriter = new StringWriter();

HtmlTextWriter htwWriter = new HtmlTextWriter(sWriter);

GridView1.RenderControl(htwWriter);

Response.Write(sWriter.ToString());

Response.End();

.net application with excel 2007

adityaraj — Sun, 22 Nov 2009 05:00:00 GMT

Hi all,

I have written an applicantion using asp.net that updates the cells of an excel page using interop services and then save that workbook later read all the computed data from that same workbook using oledb dataapadter.

Now my question is in development environment i have excel 2007 installed.But,in server we have excel 2003,so i would like to know will there be any consequenses beacuse of that.

Or it is must and should i have to use excel 2007 liscence in server also?Please suggest.Very urgent!!!!!!!!!!!!!!!!

unable to read date values from excel

anandjk1 — Wed, 18 Nov 2009 05:00:00 GMT

Hi,

I have used the code given in the below link to read data from excel file and display it on gridview.

http://www.aspfree.com/c/a/ASP.NET-Code/Read-Excel-files-from-ASPNET/

The code runs fine but the 'date' values(format type is date) present in the excel file are not read. Please suggest if have to do any additional changes.

Thanks in Advance

-Anand