Is it possible to have an .aspx page open an Excel file, import a macro (saved in a .bas text file), and then run it? I've been able to do this in the past from a MS Access application, but I have no idea where to begin with asp.net.
View 1 RepliesI want to embed a excel file with macro in web page, and execute the macro when I click a button in the excel file.
I use iframe to do it as following ,
<IFRAME WIDTH="75%" HEIGHT="55%" NAME="fframe" SRC="Calculator.xls">
<FRAME WIDTH="75%" HEIGHT="55%" NAME="fframe" SRC="Calculator.xls">
<EMBED SRC="Calculator.xls" width=200 height=100>
</IFRAME>
when i open this page via IE, It will prompt me to open or save this xls file.
But we do not want to show this prompt, we want to open it directly.
how can i do it ? or if any other solution can do the same thing?
I have been trying to import from an Excel file and insert it into a table. I can upload the Excel file. I can view the Excel file in a grid But when I run the import process to insert the rows in the Excel file I get only one row and it has all nulls except the dateentered and entered by field. I added breakpoints and tried setting a couple of the fields to labels and I could see that data was getting to the reader.
View 4 RepliesBelow is my existing import. Well what is happending is I am loosing the users ability to post the excel fiel to the web server and then import it from there. I need to import the excel file directly from their local folders. SO they need to be able to pick it from there my documents and import the file into sql. IS this possible? An how can I change my code to allow them to pick the file and then import it. Still working in asp.net 1.1.
[code]....
I have to create one page where user will upload the excel file in SQl Server and system should check following things
1.Sheet Name should be always sheet1
2.System should check the column names
3.System should show the message that these many rows has been loaded
I need to be able to have a user upload an excel file, then immediately work with that file and save the contents in a database.
I know how to do this if I save the file first, then open it using OleDB, BUT I would rather not save it first.
I am working on a C# web application under visual studio 2005.
I want to import data from text file or excel file into a SQL 2005 database.
I have 3 columns in the text file separated by |, example of the text file format:
1|11122222|Name1
2|22299809|Name2
how to import data from text or excel file?
Date format is 1:55:25 AM in the excel file, after reading using ExcelReaderFactory.CreateBinaryReader, I get the 0.0451388888888889.
View 3 Repliesim using sqlbulkcopy to import all the columns and rows in an excel file to a database. My question is, if my database has 1 more extra column which i have to map it to a session variable and that extra column in the database is not found in the excel, isit possible to do something like dat?
View 3 RepliesI got data retrieved from Sql DB in a 3 different dataset. I need to get all data from
View 7 Repliesi have different tables for product details, images, category mapping
is there any way to import/export products by excel file in database along with category mappying and pictures in one go rather that importing just the products and then categorizing each product and adding image one by one ?
I have been able to import an excel file sql bulkcopy locally. But when I publish the code to the server I get the following error messages:
Exception Message: 'C:MyTest.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
Exception Source: Microsoft JET Database Engine
Here is code:
[code]....
How do i import selected row and columm from excel file to gridview? I have 9 rows in the excel file. I would like to display only 3 rows.
View 3 RepliesIs there a way to import an amount of data from an excel sheet using the sheet rowindex, something like: SELECT * FROM [PLAN1$] WHERE ROWINDEX BETWEEN 1 AND 1000?
View 1 RepliesIn the above mentioned article at "[URL]" instead of selecting the existed table in dbserver is it possible to create a dynamic database table based upon the structure of the excel file to be loaded??
View 1 Replieshow we can acheive this. I need to import this excel file. This is a sample image. I have no. of header rows and no. of columns will differ in each header.
Here is another information about the excel file. Col cells are set with background color. IS there any way to read the values from the cells having background color
i m having excel file a.xls i m having gridview1,fileupload1 how to import excel file from fileupload1 get the destination of a.xls and show the values in gridview1
View 3 Repliesinstead of using gridview to insert student marks (I have hundreds of students) thought I used the Excel:
1) allow managers of each module after authentication to download the excel file (containing the students enrolled in the given module), the excel file ted is generated by the following code: Id_student ____ maks of subject1 -------- ----maks of subject2
[Code]....
But in this code I do not know how to:
* Add the following condition: the student'marks is between 0 and 20.
* Calculate the average of this module : sum (coeff * mark) / sum (coeff)
2) Allowing responsable module send me the file containing the data (but then I do not know how)
3) Using data, by sending them to the database to calculate averages.
I'm still struggling with my scenario. I have looked everywhere for a solution and cannot find a solution. I am using C# and ASP.NET and I need to export data to an Excel spreadsheet.
I have a list of applications that contains Application objects. Each Application object has a status ID. When I export these applications to Excel then I need a column with a drop down/combo box in it. In this drop down/combo box should be a list of all the statuses from the database. And then I need the status to be selected to that of the application's status ID.
Another question is also with regards to the above scenario. When the user downloads the Excel document then the user can change the status of each application by selecting a different value in the drop down. I will need to upload this spreadsheet and loop through the rows and get the values of the columns and the value of the selected item in the drop down/combo box. How would you do this? Is this possible?
I may not use COM components, so I tried to go with EPPlus or NPOI (it does not have to be these 2) but it doesn't seem like they support my scenario. How would I be able to achieve my scenario? Once again, it doesn't have to make use of EPPlus and NPOI.
how to do import an excel file into my MYSQL database in ASP.net C# ?
View 4 RepliesHow Can I Import,Export Exel to Sql
View 4 RepliesHow do I do that using c#?
I have a texbox and two buttons.
I want to import excel data to oracle DB.
Is it possible to import to oracledb with filehelpers?
I have a page that import data from an excel sheet and I'm facing a weird problem. The sheet has 47 columns and over almost 72,000 rows. In my workstation I can import the data without problems and I have Office 2010 installed. In the server I have installed AccessDatabaseEngine for Office 2010 and when I try to import the data I receive the following error: The external table is not in the expected format. Rememberring I'm import the data to the same database. But when I break this excel file in files with less rows, it imports without problems.
View 7 RepliesI am working on a C# web application under visual studio 2005. I want to import data from text file or excel file into a SQL 2005 database. I have 3 columns in the text file separated by |, example of the text file format:
1|11122222|Name1
2|22299809|Name2
Can you tell me how to import data from text or excel file? Another question, if you provide a solution for the import from excel, can you note which office (2003 or 2007 or 2010)?