473,320 Members | 1,900 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Creating an Excel Spreadsheet from code on a computer that does nothave Excel installed

I have an application that can read an Excel spreadsheet on a computer
that doesn't have Excel installed on using the Jet ODBC 4.0 driver.

I know need to modify the application to also be able to create a new
Excel spreadsheet and write data to it on the same computer, a
computer that does not have Excel, or even Office installed.

I have done some research on this and it appears it cannot be done.

Can anyone verify that or better yet, point me to a link that explains
how to do it?
Jan 28 '08 #1
4 1891
would you consider Excel XML.

http://www.carlosag.net/Tools/ExcelX...r/Default.aspx

Regards,

Trevor Benedict

MCSD

<za***@construction-imaging.comwrote in message
news:36**********************************@e25g2000 prg.googlegroups.com...
>I have an application that can read an Excel spreadsheet on a computer
that doesn't have Excel installed on using the Jet ODBC 4.0 driver.

I know need to modify the application to also be able to create a new
Excel spreadsheet and write data to it on the same computer, a
computer that does not have Excel, or even Office installed.

I have done some research on this and it appears it cannot be done.

Can anyone verify that or better yet, point me to a link that explains
how to do it?

Jan 28 '08 #2
Well you can write data files with a xls extension that will inmediatly be
converted by Excel when openned ( the user will not notice this )
this works for me ( office 2003 and higher )

if this might work for you i can show an example

hth

Michel

<za***@construction-imaging.comschreef in bericht
news:36**********************************@e25g2000 prg.googlegroups.com...
>I have an application that can read an Excel spreadsheet on a computer
that doesn't have Excel installed on using the Jet ODBC 4.0 driver.

I know need to modify the application to also be able to create a new
Excel spreadsheet and write data to it on the same computer, a
computer that does not have Excel, or even Office installed.

I have done some research on this and it appears it cannot be done.

Can anyone verify that or better yet, point me to a link that explains
how to do it?

Jan 28 '08 #3
On Jan 28, 5:03*pm, "Michel Posseth [MCP]" <M...@posseth.comwrote:
Well you can write data files with a xls extension that will inmediatly be
converted by Excel when openned *( the user will not notice this )
this works for me ( office 2003 and higher *)

if this might work for you i can show an example
I would like to see that please.
>
hth

Michel

<za...@construction-imaging.comschreef in berichtnews:36**********************************@e 25g2000prg.googlegroups.com...
I have an application that can read an Excel spreadsheet on a computer
that doesn't have Excel installed on using the Jet ODBC 4.0 driver.
I know need to modify the application to also be able to create a new
Excel spreadsheet and write data to it on the same computer, a
computer that does not have Excel, or even Office installed.
I have done some research on this and it appears it cannot be done.
Can anyone verify that or better yet, point me to a link that explains
how to do it?
Jan 29 '08 #4

Well one method i personally like an use a lot is this one

Imports System.Web

Imports System.IO
Private Sub CreateXLSFromDt(ByVal ds As DataSet, ByVal tablename As String,
ByVal location As String)
Dim grid As New System.Web.UI.WebControls.DataGrid

grid.HeaderStyle.Font.Bold = True

grid.DataSource = ds

grid.DataMember = tablename

grid.DataBind()

'// render the DataGrid control to a file

Using sw As New StreamWriter(location)

Using hw As New UI.HtmlTextWriter(sw)

grid.RenderControl(hw)

End Using

End Using

End Sub

usage

CreateXLSFromDt(dataset, TableNameInDataset , fullpath of file to create )

so in my situation
CreateXLSFromDt(dsBl, "tblBlok", "C:\testMp.xls") '
you just throw in a dataset and it will render the table data to a nicely
formated ( table with headers ) Excel sheet
Hope this works for you to

Michel


<za***@construction-imaging.comschreef in bericht
news:58**********************************@u10g2000 prn.googlegroups.com...
On Jan 28, 5:03 pm, "Michel Posseth [MCP]" <M...@posseth.comwrote:
Well you can write data files with a xls extension that will inmediatly be
converted by Excel when openned ( the user will not notice this )
this works for me ( office 2003 and higher )

if this might work for you i can show an example
I would like to see that please.
>
hth

Michel

<za...@construction-imaging.comschreef in
berichtnews:36**********************************@e 25g2000prg.googlegroups.com...
I have an application that can read an Excel spreadsheet on a computer
that doesn't have Excel installed on using the Jet ODBC 4.0 driver.
I know need to modify the application to also be able to create a new
Excel spreadsheet and write data to it on the same computer, a
computer that does not have Excel, or even Office installed.
I have done some research on this and it appears it cannot be done.
Can anyone verify that or better yet, point me to a link that explains
how to do it?

Jan 29 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jeff | last post by:
I will start off by giving you a background of the process I am taking. The nature of my DTS package is that I recieve an Excel Spreadsheet, run it through the DTS Package applying validation to...
3
by: bawar | last post by:
Hey, I can say I belong to the newbies in this subject. I own my own website with mySQL-databases, but now I have to show one table of those mySQL-databases in an excel worksheet. It is the...
2
by: JM | last post by:
Hi I have created a Windows Form that takes input. When the Run button is pressed the form is disabled and the code checks some files and inputs the data into an Excel worksheet (that is hidden...
5
by: Tim Marsden | last post by:
Hi I am a complete ASP novice. Is it possible to display an Excel spreadsheet in a web page? Can any input to the sheet be captured and sent back to the server? Regards Tim
1
by: Gerry | last post by:
I have an ASP.NET application installed on a Windows Server 2003 computer. MS Excel is also installed on the same computer. And yes, the application makes use of Excel. When the Application Pool...
3
by: Ken Hall | last post by:
Is it possible to create an Excel spreadsheet using VB.NET without opening the Excel application or having to have the Excel application on the operating computer? KH
3
by: | last post by:
I wrote a class in VB.NET to export the contents of a datagrid to Excel. It works perfectly on my machine, but it fails on my customers' PCs that have identical versions of Win XP (SP1) and Excel...
5
by: cdun2 | last post by:
Hello, I'm a non_VBA coder who has been asked to update the following Function: ************************** Function EMAILER_REV_BY_ACCTCODE_MACRO() On Error GoTo RA_EMAILER_Err ...
5
by: Louis | last post by:
I am trying to use php to update a spreadsheet (MS Excel or OpenOffice Calc) with data from MySQL. I looked into PEAR::Spreadsheet_Excel_Writer if it will do the job. If I understand it...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.