Trying to use xp command shell to export data out to Excel

Hi ,

     I have a requirement where i need to export the gridview data to excel.My code export the data in excel that was fine.

But the enchancement needed now , I was exporting the 3 gridview in same excel sheet under the workbook.

Now i need to export the 3 grid view in 3 different sheet in the same workbook.

so can please tell or share the updated code in my below code ...

public void writeovrsummary()
    {

Response.Write("<BR>");

        Response.Write("Overall Summary");
        //Response.Write("<BR>");
        //Response.Write("Report as of " + DateTime.Now.ToString("hh:mm ss tt"));

        StringWriter sw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(sw);

        SqlCommand com = MyConnection.CreateCommand();
        com.CommandText = "useroverall_Report";
        SqlParameter[] par = new SqlParameter[1];
        par[0] = new

Hi All,

I have assigned a work to create a report, that should render in excel with dropdown list. i.e. report should contain a input parameter as a table names, when user selects the table name, report should show only the field names of the selected table. Some of the field name have look up values that values should be displayed as dropdown when we export to excel.

Can any one have any idea how to proceed with this report?

Thanks,

Karthik 

Hi ,

I need to import based selective data from excel sheet and export data from sharepoint list, I'm new in Sharepoint.

can anybody guide me? What all possible ways are there and which would be the best.

Thanks

hi,

i am using master page and child pages in the child page

i want to export the gridview data to excel sheet for this i use the following code

       Response.ClearContent();

        Response.AddHeader("content-disposition", "attachment; filename=shedules.xls");

        Response.ContentType = "application/excel";

        StringWriter sw = new StringWriter();

        HtmlTextWriter htw = new HtmlTextWriter(sw);

        grdshedules.RenderControl(htw);

        Response.Write(sw.ToString());

        Response.End();

but in the gridShedules.RenderControl(htw) i got the following error but the form tag with  runat= server is already in the master page how to solve this issue

error:Control 'ctl00_ContentPlaceHolder1_grdshedules' of type 'GridView' must be placed inside a form tag with runat=server.

I am trying to export some data from a simple three-column table on my SQL 2008 R2 instance to Excel 2007 (also happens in Excel 2003). Our data has a lot of foreign (Hebrew) characters on it and although the copy works ok, the data as it appears in Excel is gibberish.

The source table in SQL contains three columns:

• smallint - numbers
• varchar(30) - hebrew text
• varchar(50) - hebrew text
• varchar(15) - hebrew text

When I fire up the Import-Export wizard I see the following: http://img524.imageshack.us/img524/1830/sqltable.png. When I click on the yellow warning for a conversion problem, I see this: http://img375.imageshack.us/img375/4255/conversion.png.

Do I need to modify the core SQL or change the data type? I already tried modifying the destination datatype to be varchar instead of LongText but that didn't help.

Any assistance would be fantastic!

HI,

I am new to SSRS. I have a report with a pie chart . When I export the report in excel format, pie chart is displayed as picture. I want it to be displayed as editable pie chart with data. 

The requirement is, if user want to change the data in excel sheet after exporting, changes should reflect in pie chart of that excel sheet.

Please suggest me the way of achieving it.

Thanks.

Hello,

Just starting to convert my large Access VBA application to asp.net vb. I have done classic asp in the past but been doing VBA for last 3 years.

Just trying to get pointed in the right direction. I am looking to export data to an excel file. I have searched a bit and got my page to export a data table to a tab delimted file and also used the HtmlTextWriter to take the data from a gridview. However I am trying to find something with a little more control I think without losing me : ). I would like to be able to export directly to excel with out displaying it on the page and also have a couple different datasets export to the same excel file with multiple worksheets.

Thanks

JTC

Hello

I got a problem with datatransfer via Microsoft.JET.OLEDB.4.0.

As long as I use the following statement it's working but only 255 Characters will be transferred to Excel.

INSERT INTO OPENROWSET('Microsoft.JET.OLEDB.4.0','Excel 8.0;HDR=YES;Database=C:\xxxxxx.XLS','SELECT F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12 FROM [Tabelle1$]')SELECT TOP 65000 [Störungsnummer], CONVERT(varchar(50),[Annahmedatum],120) AS [Annahmedatum], CAST([Teilnehmernummer A] AS VARCHAR(255)) AS [Teilnehmernummer A], CAST([Annahmeperson] AS VARCHAR(255)) AS [Annahmeperson], [Annahmeplatz], CAST([Störungscode] AS VARCHAR(255)) AS [Störungscode], [Störungscode Nummer], CAST([Störungsmeldungstext] AS VARCHAR(255)) AS [Störungsmeldungstext], CAST([Wartungsvertrag] AS VARCHAR(255)) AS [Wartungsvertrag], CAST([SOSegment] AS VARCHAR(255)) AS [SOSegment], CAST([Kundensegment] AS VARCHAR(255)) AS [Kundensegment], CAST([TDV] AS VARCHAR(255)) AS [TDV] FROM [yyyyyyyyyyyy].

As soon as I try to extend the varchar over the limit of 255 the following error occurs:

String or binary data would be truncated. Export ERROR: XLS - Export in work.. (Microsoft.JET.OLEDB) The statement has been terminated.