Here's the scenario I've been approached with -
We have an Excel template - what I need to do, is use that Excel template,
hit a database, and refresh the data within the Excel sheet with the new
data.
Anybody have a link on a VB.Net sample, for something like this?
5  1242 
From Google search... http://www.vbdotnetheaven.com/Upload...readsheet.aspx
Lit
"SimpleMan75" <sm@here.comwrote in message
news:uK**************@TK2MSFTNGP05.phx.gbl...
Here's the scenario I've been approached with -
We have an Excel template - what I need to do, is use that Excel template,
hit a database, and refresh the data within the Excel sheet with the new
data.
Anybody have a link on a VB.Net sample, for something like this?
Thank you, but that did not answer my question - - -
I know how to create an Excel sheet - basically, I know how to open an
existing file
I need to know how to open a file/existing template, and hit a stored
procedure, to get/refresh the data, and then, put that data inside the open
file, in the correct place, based on the template
"Lit" <sq**********@hotmail.comwrote in message
news:u$**************@TK2MSFTNGP03.phx.gbl...
From Google search...
http://www.vbdotnetheaven.com/Upload...readsheet.aspx
Lit
"SimpleMan75" <sm@here.comwrote in message
news:uK**************@TK2MSFTNGP05.phx.gbl...
>Here's the scenario I've been approached with -
We have an Excel template - what I need to do, is use that Excel
template, hit a database, and refresh the data within the Excel sheet
with the new data.
Anybody have a link on a VB.Net sample, for something like this?
"SimpleMan75" <sm@here.comwrote in message
news:O4****************@TK2MSFTNGP05.phx.gbl...
Thank you, but that did not answer my question - - -
I know how to create an Excel sheet - basically, I know how to open an
existing file
I need to know how to open a file/existing template, and hit a stored
procedure, to get/refresh the data, and then, put that data inside the
open file, in the correct place, based on the template
For that, you'll need Aspose: http://www.aspose.com/Products/Aspos...s/Default.aspx
--
Mark Rae
ASP.NET MVP http://www.markrae.net http://forums.devx.com/showthread.php?t=155202
Lit
"SimpleMan75" <sm@here.comwrote in message
news:O4****************@TK2MSFTNGP05.phx.gbl...
Thank you, but that did not answer my question - - -
I know how to create an Excel sheet - basically, I know how to open an
existing file
I need to know how to open a file/existing template, and hit a stored
procedure, to get/refresh the data, and then, put that data inside the
open file, in the correct place, based on the template
"Lit" <sq**********@hotmail.comwrote in message
news:u$**************@TK2MSFTNGP03.phx.gbl...
>From Google search...
http://www.vbdotnetheaven.com/Upload...readsheet.aspx
Lit
"SimpleMan75" <sm@here.comwrote in message
news:uK**************@TK2MSFTNGP05.phx.gbl...
>>Here's the scenario I've been approached with -
We have an Excel template - what I need to do, is use that Excel
template, hit a database, and refresh the data within the Excel sheet
with the new data.
Anybody have a link on a VB.Net sample, for something like this?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: jimserac |
last post by:
I had previously posted this in an Access forum
with negative results so will try here.
Although this question specifies an Access database,
I also wish to accomplish this with a large MS SQL...
|
by: Sam Johnson |
last post by:
HI
I tried to send the following SQL string to an open
databse, to export a table into excel format:
g.Connection = conn 'valid OleDBConnection and Command
objects
g.CommandText = "SELECT *...
|
by: George |
last post by:
Sub ExcelToListBox()
Dim xRange As Object
Dim ary
Dim xValue As String
xRange = oXL.Range("A1:A9") 'has letters A-H
ary = xRange.value
xValue = ary(3, 1) 'xValue = C...
|
by: wreckingcru |
last post by:
I'm trying to output a SQL query that is constructed thru my VB.net GUI
into an excel file.
Here is the code I'm using:
'Sqlstmt is the SQL query statement
'Conn is the SQL Connection object...
|
by: Mad Scientist Jr |
last post by:
>From an asp.net web page I want the user to open the results of a SQL
query in Excel, as automatically as possible (ie not having to loop
through columns, rows, in code).
For this,...
|
by: Gunawan |
last post by:
Dear All,
I have create an excel (COM Object) using this code
Excel.Application xls = new Excel.Application();
but I can not remove it from memory although I have using close and quit
...
|
by: Doug Glancy |
last post by:
I got the following code from Francesco Balena's site, for disposing of Com
objects:
Sub SetNothing(Of T)(ByRef obj As T)
' Dispose of the object if possible
If obj IsNot Nothing AndAlso...
|
by: ddecoste |
last post by:
I have a need to add a visual representation to some data in Access.
I need to draw a matix of squares inside another square. I have all
the data that I need in a record in Access. The data...
|
by: pleaseexplaintome_2 |
last post by:
using the code below (some parts not included), I create a new excel
workbook with spreadheets.
I then want to delete a spreadsheet, but a reference remains open and
excel stays in task manager...
|
by: akristensen |
last post by:
I am new to this site, so be patient if I do not ask the question correctly.
Current Target Platform: Browser: MS IE, script language: Javascript (will use VBScript, but JS is preferred), External...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
