Can Import And Execute A Macro Into An Excel File?

Oct 27, 2010

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 Replies


Similar Messages:

How To Embed Excel File With Macro In Aspx Page

Nov 29, 2010

I 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?

View 3 Replies

Web Forms :: Trying To Import From Excel File

Oct 7, 2010

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 Replies

Web Forms :: Import Excel File Into Sql

Jan 21, 2010

Below 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]....

View 2 Replies

Databases :: Import Excel File In SQL Server?

Sep 27, 2010

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

View 1 Replies

Databases :: Upload And Import Excel File Without Saving First?

Apr 13, 2010

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.

View 3 Replies

Databases :: Import Data From Text Or Excel File?

Feb 8, 2011

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?

View 3 Replies

Date Format Lost When Import Excel File In C#?

Aug 31, 2010

Date format is 1:55:25 AM in the excel file, after reading using ExcelReaderFactory.CreateBinaryReader, I get the 0.0451388888888889.

View 3 Replies

SQL Server :: Import All The Columns And Rows In An Excel File To A Database?

Aug 31, 2010

im 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 Replies

DataSource Controls :: Import Data From Dataset To Excel File?

Feb 2, 2010

I got data retrieved from Sql DB in a 3 different dataset. I need to get all data from

View 7 Replies

DataSource Controls :: How To Import / Export Products By Excel File In Database

Feb 7, 2010

i 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 ?

View 4 Replies

Import Excel File To Sql Using Bulkcopy / Exception Message: 'C:MyTest.xls' Is Not A Valid Path

Mar 2, 2011

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]....

View 2 Replies

Forms Data Controls :: Import Selected Row And Column From Excel File To Gridview?

Nov 10, 2010

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 Replies

Databases :: Want To Import Excel Data By Excel Rowindex?

Mar 11, 2011

Is 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 Replies

Data Controls :: Import Excel To Dynamically Created Table Based On Excel Data

Nov 22, 2015

In 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 Replies

Excel Import To Database Using C#?

Sep 24, 2010

how 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

View 1 Replies

Import Data Of Excel Into Gridview1

Aug 31, 2010

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 Replies

Excel Import And Export Is Good Way

May 29, 2010

instead 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.

View 3 Replies

C# - Export / Import To Excel With Combo Box?

Nov 11, 2010

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.

View 1 Replies

Databases :: Import From Excel Into Mysql In C#?

Sep 30, 2010

how to do import an excel file into my MYSQL database in ASP.net C# ?

View 4 Replies

Databases :: How To Import Export Excel

Feb 21, 2011

How Can I Import,Export Exel to Sql

View 4 Replies

Databases :: Import Data From Excel To SQL?

Mar 30, 2011

How do I do that using c#?

I have a texbox and two buttons.

View 2 Replies

Import Excel Data To Oracle DB?

Jan 25, 2010

I want to import excel data to oracle DB.

Is it possible to import to oracledb with filehelpers?

View 3 Replies

Web Forms :: Import Data From Excel Sheet

Mar 3, 2011

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 Replies

Web Forms :: Import Data From Text And Excel

Feb 10, 2011

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

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)?

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved