I have an excel sheet that has several lines. Each line is an order. Example:
1 Paper 10
2 Pencils 20
etc...
When the excel sheet is filled out I want the user to press a button and
then the data from orderlines is extracted and placed in a seperate file.
This seperate file and the original excel sheet should be placed in a temp
dir and then an executeble is going to be started to import both into another
application.
My question is:
Should I create a solution based on Visual Studio Tools for Office 2005 or
is creating an Add-In for excel the best way to go?
17  9864 
Hi Philip,
WE can use ado.net to retrieve the data from excel as a datasource.
316934 How To Use ADO.NET to Retrieve and Modify Records in an Excel
Workbook With Visual Basic .NET http://support.microsoft.com/default...b;EN-US;316934
Best regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
Thank you for your quick response.
The KB article you referred to is very helpful. However this is a windows
forms application. I want the user to use the functionality from within Excel.
What is the best way to go? Add-In for excel or Visual Studio Tools for
Office 2005?
""Peter Huang" [MSFT]" wrote: Hi Philip,
WE can use ado.net to retrieve the data from excel as a datasource.
316934 How To Use ADO.NET to Retrieve and Modify Records in an Excel
Workbook With Visual Basic .NET
http://support.microsoft.com/default...b;EN-US;316934
Best regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
That uses the Microsoft Jet OLEDB driver. Isn't the current recommended
way to do it is with the Microsoft Excel Driver?
You need to specify the xls file in the connectionstrin g. But I do not know
how the xls file is saved or where. Anyway around this?
"za***@construc tion-imaging.com" wrote: That uses the Microsoft Jet OLEDB driver. Isn't the current recommended
way to do it is with the Microsoft Excel Driver?
Hi Philip,
To access to the Excel data, we have two approaches.
1. Using the Microsoft Jet engine, So we can use the ADO in Legacy
application(vb6 ,vba) or ADO.NET in .NET application.
2. Using Excel Object Modal which is somewhat less efficient for block of
data than above.
But either methods, we need to know where the xls file is, because we need
to load the file so that we can retrieve the data.
If I have any misunderstandin g, can you describe your scenario more
detailed?
Thanks!
Best regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
"Philip Wagenaar" <ph************ *@online.nospam > wrote in message
news:33******** *************** ***********@mic rosoft.com... I have an excel sheet that has several lines. Each line is an order.
Example:
1 Paper 10
2 Pencils 20
etc...
When the excel sheet is filled out I want the user to press a button and
then the data from orderlines is extracted and placed in a seperate file.
What sort of file?
flat text file. Tab delimited
"Homer J Simpson" wrote:
"Philip Wagenaar" <ph************ *@online.nospam > wrote in message
news:33******** *************** ***********@mic rosoft.com...I have an excel sheet that has several lines. Each line is an order.
Example:
1 Paper 10
2 Pencils 20
etc...
When the excel sheet is filled out I want the user to press a button and
then the data from orderlines is extracted and placed in a seperate file.
What sort of file?
Hi Philip,
Have you tried my suggestion?
If you means a plain text which is Tab delimited, you may try to import it
into excel as a xls file and then use the ADO or ADO.NET to retrieve the
data.
If you still have any concern, please feel free to post here.
Best regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
"Philip Wagenaar" <ph************ *@online.nospam > wrote in message
news:01******** *************** ***********@mic rosoft.com... flat text file. Tab delimited
I can't imagine doing anything but writing this in Excel VBA. Piece of cake
and exactly what it is meant for.
Just record a macro of doing this by hand then go in and tweak it to make it
more general. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: pmud |
last post by:
Hi,
I need to use an Excel Sheet in ASP.NET application so that the users can
enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever
the USER ENETRS needs to go to the SQL DATABASE, probably by the click of a
button.
Is this possible? & what is the BEST APPROACH for doing this? & also if any
links are there do...
|
by: surekhads |
last post by:
Hi all,
I have developed a project for extracting data from a HTML file and export that data to a excel sheet. I am storing that extracted data to the db. And then I am exporting that data to excel sheet. But, the data is getting overwritten in that excel sheet each time. I want to get rowcount from excel sheet & then append new data to...
|
by: pvenu |
last post by:
Hi,
I know basic perl (regular expressions, pattern matching, string manipulation, reading writing into text files).
Yet, my requirement is to read an input text file -> process this input file through a Perl script and the output generated from this script is to be written into an Excel sheet file (into each cells of the sheet).
Can you...
|
by: manishabh77 |
last post by:
I will be obliged if anybody can help me with this problem:
I am trying to extract data from an excel sheet that matches IDs given in column 4 of the excel sheet.I have stored those query IDs in an array (@names). After I look for the match in this section of the code:
if ($value=~/^$names$/), I want to write out only those rows that satisfy the...
|
by: TG |
last post by:
hi!
I am trying to create a sql server table from an excel sheet.
Here is the code I have:
'This procedure the xlsx file and dumps it to a table in SQL Server
| | |
by: Gilbert Tordeur |
last post by:
Hello !
My web application generates an Excel sheet on the server. Then I would like
to generate a pdf file from this Excel sheet. How can I do ?
Thank you for your help,
Gilbert
|
by: todubhai |
last post by:
I am using the following code to extract the sheet names from excel: (See attached code)
private String GetExcelSheetNames(string sConnectionString)
{
OleDbConnection objConn = null;
System.Data.DataTable dt = null;
try
{
// Create connection object by using the...
|
by: PeacefulSoul |
last post by:
Hello,
I have a lot of excel sheets which columns are slightly different, i want to import all of these sheets (one at a time) into ONE SQL TABLE. I'll give an example :
Say ive written the required program and called it Excel2sql converter. So Excel2sql takes an excel sheet and create a database table with the data of that excel sheet, For...
|
by: putt73 |
last post by:
In order to create styles for an excel sheet like applying border, background color, font what is the common function used?
Is there any function to get the styles (format) of an existing excel sheet?
|
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...
|
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...
| | |
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
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...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
