Something like this can be used to work with Excel in VB.Net.
You might need to download and install
Microsoft.Visua l.Studio.Tools. for.the.Microso ft.Office.Syste m to be able to
do this.
Imports Office = Microsoft.Offic e.Core
Imports Excel = Microsoft.Offic e.Interop.Excel
objExcel = CreateObject("e xcel.applicatio n")
objBook = objExcel.Workbo oks.Open("C:\te st.xls")
objSheet = objBook.Workshe ets(1)
objSheet.Activa te()
objSheet.Cells( 1, 1) = "descriptio n"
objExcel.Active Workbook.SaveAs ( "c:\test.xl s" )
objExcel.Active Workbook.Close( savechanges:=Fa lse)
objSheet = Nothing
objBook = Nothing
objExcel = Nothing
"steve" <st***@here.com > wrote in message
news:i3******** *************@w agner.videotron .net...
Hi,
I have generated a datagrid with the following columns:
| Date-Time | Station ID | Parameter1 | .... | Parameter 2|
I would like to:
Create an Excel file and preferably give the user a choice to create one
separate Excel file per Station ID.
Also, later on i want to perform various statistics on the data that is
too
hard to do with SQL (moving averages, etc.), since a datagrid means that
the data resides in memory , is it the best choice for me?
I mean, Create a Dataset, Populate a Datagrid, then do the statistics
through VB ?
Any suggestions, comments would be greately appreciated!
TIA
-steve