Retrive data from an client side Excel source

=?Utf-8?B?UGV0ZXIgSiwgU2Nhbmlh?=

Hello

I'm looking for an solution about how to retrive data from an client side
located Excel document by using an ASP.Net application. I don't want to
upload the file to the server. I just want to get the data and persist it in
an database after that some business validation have been done.

Does anyone have any idea?

Mar 30 '07 #1

Subscribe Reply

1959

Mark Rae

"Peter J, Scania" <Pe**********@d iscussions.micr osoft.comwrote in message
news:CC******** *************** ***********@mic rosoft.com...

I'm looking for an solution about how to retrive data from an client side
located Excel document by using an ASP.Net application. I don't want to
upload the file to the server. I just want to get the data and persist it
in
an database after that some business validation have been done.

Does anyone have any idea?

You're going to really struggle with this, especially if this is a public
Internet app...

If you don't want to upload the Excel spreadsheet, you're going to have to
develop an ActiveX solution to open the spreadsheet client-side and extract
the data you want.

Obviously, you'll have to really ramp down the security in order to do this,
as under normal circumstances web browsers have no interaction with the
client hardware...

Obviously, ActiveX controls will only work in IE...

Is there any particular reason you don't want to upload the spreadsheet to
the server...? If you did that, this would be a fairly simple matter...

Mar 30 '07 #2

=?Utf-8?B?UGV0ZXIgSiwgU2Nhbmlh?=

Hello Mark

I agree with you on the security issue.

Is it possible to stream the spreadsheet to the server and from there
retrive the data I want to handle? Or do you have other solutions?

\Peter

"Mark Rae" wrote:

"Peter J, Scania" <Pe**********@d iscussions.micr osoft.comwrote in message
news:CC******** *************** ***********@mic rosoft.com...

I'm looking for an solution about how to retrive data from an client side
located Excel document by using an ASP.Net application. I don't want to
upload the file to the server. I just want to get the data and persist it
in
an database after that some business validation have been done.

Does anyone have any idea?

You're going to really struggle with this, especially if this is a public
Internet app...

If you don't want to upload the Excel spreadsheet, you're going to have to
develop an ActiveX solution to open the spreadsheet client-side and extract
the data you want.

Obviously, you'll have to really ramp down the security in order to do this,
as under normal circumstances web browsers have no interaction with the
client hardware...

Obviously, ActiveX controls will only work in IE...

Is there any particular reason you don't want to upload the spreadsheet to
the server...? If you did that, this would be a fairly simple matter...

Mar 30 '07 #3

Mark Rae

"Peter J, Scania" <Pe**********@d iscussions.micr osoft.comwrote in message
news:46******** *************** ***********@mic rosoft.com...

Is it possible to stream the spreadsheet to the server and from there
retrive the data I want to handle? Or do you have other solutions?

Absolutely!

1) Use an <asp:FileUpload webcontrol to allow the user to specify what
spreadsheet to upload
http://msdn2.microsoft.com/en-us/lib...ileupload.aspx

2) Use ADO.NET to extract the data
http://www.google.co.uk/search?sourc...DO%2eNET+Excel

Mar 30 '07 #4

Similar topics

9537

Urgent:Copy data from notepad/excel..simple though

by: cv | last post by:

Hi all, I have to copy two set of data from 2 files(notepad/excel) say, products and their corresponding prices to list/textarea/table. I should be able to retrieve the product and corresponding price information from the control(list/textarea/table). Which is the best way? Quite urgent.. pls let me know. TIA, cv

Javascript

15497

How to import/map excel table data to access table data?????

by: Fred | last post by:

Hi. How do I import while mapping an excel table to an access table please??? I've searched around and all I can find is a software product or code that does the same thing as the access wizard..... If I have to write vb code, where is a sample??? Or do I import the excel in to a new spreadsheet and then write some kind of querey to move the data from that table

Microsoft Access / VBA

1360

how to retrive client side file information

by: sonu | last post by:

how to retrive client side file information through .NET Any link or information please ?

C# / C Sharp

12066

Safety settings on this computer prohibit accessing a data source on another domain

by: sonu | last post by:

I have following client side code which i have used in my asp.net project SummaryFeatured Resources from the IBM Business Values Solution Center WHITEPAPER : CRM Done Right Improve the likelihood of CRM success from less than 20 percent to 60 percent. WHITEPAPER :

.NET Framework

1792

Can I retrive a session object by a session ID?

by: Toto | last post by:

Can I retrive a session object by a session ID which is stored in a cookie in my server side code?

ASP.NET

3532

Help with first VB application - Data Entry form

by: Timothy.Rybak | last post by:

Hello all, This is my first attempt at an application, so kid gloves are appreciated. I need to make a very simple form that only has a few elements. One is TraceCode - a text field that is populated when a user scans a label. The other is ScanDate - a date/time field that should equal the date/time of the scan (e.g. 7/31/2006 5:00:00 AM).

Visual Basic .NET

1222

Creating a Data Source

by: Mel | last post by:

I have Visual Basic code in the Page_Load event that makes a connection to an Excel 11.0 file. Is it possible to do the equivalent using a data source so it existed on the form? If so, how? A data source would be handy since I need to retrieve the Excel data from many procedures/functions in my VB code. Dim appExcel As New Excel.Application Dim wkbExcel As Excel.Workbook appExcel = CreateObject("Excel.Application")

ASP.NET

2980

How to retrive image file from MS access database and display this in another JSPpage

by: amritranjan | last post by:

How to retrive image file from MS access database and display this in another JSPpage -------------------------------------------------------------------------------- This is my Jsp code for image upload in database: -----------Upload.jsp---------------- <html> <head> <title>Account Details </title>

Java

2933

Can this be done using a Data adapter??

by: insirawali | last post by:

Hi all, I have this problem, i need to know is there a way i cn use the data adapter's update method in this scenario. i have 3 tables as below create table table1{ id1 int identity(1,1) Constraint pk_table1 Primary Key,

C# / C Sharp

7884

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8267

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8380

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8024

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8258

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5423

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

2394

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1493

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1229

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General