I have the following code i found online and it works fine as long as the sheet names are simple names it seems..
If i have a excel file with a sheet name of (sheet1) the code works.. but if i have a file with a sheet name like (FileName2011_03_03_15_01_43) it fails and causes the rest of my code not work..
[Code]....
I a now Porting a data from Uploaded Excel File to database. In that, I need to check "Sheet name" Of that Excel file Whether it is Sheet1 or Sheet2 or something else...
how to Check/Read Excel Sheet name at runtime..
I am having list of records to insert in the sql. For that i need to get the sheet name.
How to get the sheet name of the excell in code behind.
I have a problem that currently we are use a sybase database and we want to create application that give me a output in excel report that's mean my data stored at sybase or mysql and we access it from this after it generate my report in excel form and give this output on excel format?
View 1 Repliesim trying to read column names from excel .
View 3 RepliesI want to fetch data from a excel sheet. Can anyone tell me how we can acheive this I also want to edit that data and then again place it on excel sheet.
View 6 Repliesi want to find data from excel sheet using c# my excel sheet like this
Sr. No.
Store Code
Store Name
City
State
1
3062
C.G.Road.
Ahmedabad
Gujarat
2
3103
Iscon Mega Mall 2
Rajkot
Gujarat
3
3113
New Gandhi Nagar
Ghaziabad
Delhi
4........................
I am doing Import/Export. While export i want to disable some column in excel sheet, so during upload or import same primary key I can use, instead of user modify such column.
View 1 RepliesI want to create a application which can be able to read data from excel sheet and process and print it.
View 3 RepliesI have write the code for deleting the data in excel sheet. but we have got the error" Deleting data in a linked table is not supported by this ISAM."
below I paste some code snippest.
string strDelete = "Delete from [" + strSheetName + "$]";
cmdExcel.Connection = con;
cmdExcel.CommandType = CommandType.Text;
cmdExcel.CommandText = strDelete;
cmdExcel.ExecuteNonQuery();
I have write the code for deleting the data in excel sheet. but we have got the error" Deleting data in a linked table is not supported by this ISAM." below I paste some code snippest.
string strDelete = "Delete from [" + strSheetName + "$]";
cmdExcel.Connection = con;
cmdExcel.CommandType = CommandType.Text;
cmdExcel.CommandText = strDelete;
cmdExcel.ExecuteNonQuery();
i got the different datatable value using different query.Now i want to export to excel at the single sheet like datatable1 to sheet1 and datatable2 to sheet2 .
View 6 RepliesI have a excel sheet and I want to make the 2nd row my header column and read the data from the 3rd row, considering 2nd row is the Column name.
View 1 RepliesI didn know where to post this query so m posting it here
I am tryin to export the data from d database to an excel sheet m using d following stored procedure for this
[Code]....
BlogAssignment being my database name and Data_Table my table.
Trial.xls is the excel sheet where i am trying to insert the data.
I am getting the follwoing error
[Code]....
I am trying to Importing Excel sheet into Sql server table using OleDbDataReader
the problem is it is not fetching the cell values with contains "," (comma) ex: cell value ="03280, 03281"
i am using OleDbConnection oconn =
new
OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
+ Server.MapPath("Files\LineItems.xlsx") +
";Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1';");
i have made a connection and retrieve the data from the excel sheet. however when i run a query to update or insert some data into excel sheet it will generate an error "Cannot expand named range"
View 2 Repliesthere is broblum for uploading excel sheet when my application runing on local host but there is no problum on vs enviroment . i am using the following connection string code
strConn =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + path +
";Extended Properties=Excel 8.0;"
;
I want to upload csv file and import the data into sql. but I cant do the import thing. The file is uploaded but it cannot be imported into sql. This is my code. Hope that someone can tell me what is the problem.
[Code]....
I have an C# ASP application I am writing that needs to have the capability to import a generated excel or a comma delineated sheet each day. A clerk will have this job each morning so it doesn't need to be automated. My problem in trying to understand the solution to this is that the 1 sheet contains loan information, including customer information all in the same sheet. I would like to send certain columns to update information in the loan table and send other information to update the customer table. I need it to create relationships when new loans appear in the spreadsheet.
View 1 Repliesusing below code im reading excel sheet data by specifying the sheet name as [Project1$] but, how do i call the excel sheet without specifying the sheet name so, that it will ready any files.
string strFileName = FileUpload1.PostedFile.FileName;
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFileName + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection objConn = new OleDbConnection(connectionString);
objConn.Open();
String strConString = "SELECT * FROM [Project1$]";
I am developing web application using csharp.How can I select details from Microsoft Excel sheet without writing sheet Name? At the moment when selecting details from Excel sheet I specify Excel sheet name like below I am using Payments$. Is it possible to use a number or something else.
[Code]....
I have one big problem for my, of course :)I have one page in my VB .NET website that contains 2 gridviews :GridView1 and GridView2I want to get one exel file with 2 sheets ( sheet A and Sheet B ), Sheet A want to contain data from GridView 1 and Sheet B i want to contain data from GridView 2I just know to save one excel file from one gridview, nd I'vesearched Google for some example but nothing for my case
View 2 RepliesI want to give product details in excel sheet but that excel sheet should be zipped and then pass it to user.
I know how to create excel sheet from database but how to pass that excel sheet into folder and then zip that folder..?
anybody working on data exporting? I've 4 tables in my sql server database. I want to export these 4 tables data into one excel file in different sheets with column names.
View 7 RepliesI am trying to import excel sheet, got an error like "
The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data"
I have given all necessary permissions but no luck..