I am trying to use php to update a spreadsheet (MS Excel or OpenOffice
Calc) with data from MySQL.
I looked into PEAR::Spreadshe et_Excel_Writer if it will do the job. If I
understand it correctly, it basically creates spreadsheets, but not
opening an existing spreadsheet and then updating and saving it, which
is what I want to do.
Do you know if there is any package out there that can do what I described?
Thanks you. 5 1777
On Fri, 10 Aug 2007 18:47:05 +0200, Louis <t0*****@hotmai l.comwrote:
I am trying to use php to update a spreadsheet (MS Excel or OpenOffice
Calc) with data from MySQL.
I looked into PEAR::Spreadshe et_Excel_Writer if it will do the job. If I
understand it correctly, it basically creates spreadsheets, but not
opening an existing spreadsheet and then updating and saving it, which
is what I want to do.
Do you know if there is any package out there that can do what I
described?
If you can get directly to the database, I'd advise skipping PHP all
together, and make an ODBC connection to MySQL, which Excel itself can
then use as it's datasource.
--
Rik Wasmus
If you can get directly to the database, I'd advise skipping PHP all
together, and make an ODBC connection to MySQL, which Excel itself can
then use as it's datasource.
I missed mentioning that the whole application starts from the web. I
have to trigger this Excel update operation through a button on the web
form.
When user clicks the button, I start a javascript function and that's
where I contemplate options of doing this. One of the options is to use
ajax request to call a php script on the server, and that's the question
I have on this newsgroup.
The other option is to run a perl script instead of php on the server to
do this. I have an example of perl script to update excel. However I
have no idea how to get apache to execute this perl code as a script
instead of a cgi script which displays the perl script code!
Thanks for your time.
On Aug 10, 11:06 am, Louis <t051...@hotmai l.comwrote:
>
I missed mentioning that the whole application starts
from the web. I have to trigger this Excel update operation
through a button on the web form.
Er, something doesn't make sense here. The Excel spreadsheet that
needs updating resides on Computer A. The Web application and its
data reside on Computer B. If you want data updated on Computer A,
but trigger this update from Computer B, Computer B needs read-write
access to Computer A (read to get the existing spreadsheet, write to
update it)... Can you provide it?
In actual systems (Bloomberg Excel API comes to mind), the initiative
usually comes from within an Excel spreadsheet. You write an add-on
that implements one or more custom spreadsheet functions; every time
the spreadsheet is opened (or even in real-time, if you prefer), the
add-on connects to your Web service and retrieves the data requested
by cells containing the calls to custom functions...
Cheers,
NC
Louis,
Do you want to save the spreadsheet on the server, or on the users PC?
-- Bill
"Louis" <t0*****@hotmai l.comwrote in message
news:dE0vi.1010 80$xk5.28443@ed tnps82...
>I am trying to use php to update a spreadsheet (MS Excel or OpenOffice Calc) with data from MySQL.
I looked into PEAR::Spreadshe et_Excel_Writer if it will do the job. If I
understand it correctly, it basically creates spreadsheets, but not
opening an existing spreadsheet and then updating and saving it, which is
what I want to do.
Do you know if there is any package out there that can do what I
described?
Thanks you.
AlterEgo wrote:
Louis,
Do you want to save the spreadsheet on the server, or on the users PC?
I am thinking of storing the spreadsheet on the server.
Thank you. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Spacy |
last post by:
Am creating a HTML Report in asp.net. To save this report to excel on
client-side, i write this code:
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("content-disposition", "attachment; filename=Report.xls")
But once the report is saved in excel, on click of hyperlink for second html
report, i dont get the second report. the same old first html report is
displayed.
Please can anyone help me. Am frustrated with...
|
by: Jane |
last post by:
I got the web application to open up the excel. It works fine on my
development box. But when i moved it to the production server, I cannot get
the Excel spreadsheet to open. I get System.UnauthorizedAccessException:
Access is denied.
I've granted full access for the excel file stored in the server, but still
can't access it. Please help!
|
by: acharyaks |
last post by:
Hi life saver,
I am using excel component for the development.
The purpose is to connect to excel through the odbc
connection string. Then through the connection extract
data into a dataset and then save the data into a client
machine (Intranet) as excel page using the excel
component (using Excel = Microsoft.Office.Interop.Excel;)
in the code.
Please help me. I have wasted so many days on this.
|
by: Matthew Wieder |
last post by:
I have the following requirements:
Build a stand-alone C# application that asks the user to click in a cell
in an Excel spreadsheet, and then displays the address of that cell in
the C# application. It seems simple enough, but the problem I'm
encountering is as follows:
In order for the user to select the cell from Excel, they must first
click once on the Excel window to give it focus and then their second
click is what changes the cell...
|
by: Denis Brkljacic |
last post by:
Hello,
Please, if enaybody could help a little bit... Namely, I need to build C#
ASP.NET Web that opens some Template.xls, write something to it and then
closes it (and releases the objects). Well, what actually happens is that I
simply manage to open the Excel file (somewhere in the filesystem on the
server), then I manage even to write something to it, but when I release all
the object, there's always EXCEL.EXE in task manager on the...
| |
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 tell those to me too coz I have no idea how to go about
doing it.
|
by: Mustufa Baig |
last post by:
Hi everybody,
I have an ASP.NET website where clients can view their monthly billings by
selecting different options. One of the option is the way they want to see
the report i.e. whether they want to see it in PDF or EXCEL etc etc.....
What I am trying to acheive is depending on their choice of format, I want
to send the stream of that particulae selected format to the browser. I have
tried couple od solutions but I couldn't able to get...
|
by: Coleen |
last post by:
Hi All :-)
I'm using .Net Framework 1.1, VB and need to be able to download the data
from a datagrid into an Excel 2000 spreadsheet for our accounting users.
Can anyone please point me to a good link on how to do this or give me some
pointers? TIA,
Coleen
|
by: Bharathi |
last post by:
Hi,
I got strucked with reading date value from excel file using
C#.NET.
For Jan-2000 the value I am getting is 36526.0.
For all other dates also I am getting some double value like this.
Is there any manipulation so that I can find out the date entered in
|
by: =?Utf-8?B?YzY3NjIyOA==?= |
last post by:
Hi all,
I have a question for you.
I have a .csv file which has many lines of data.
Each line has many data fields which are delimited by ",".
Now I need to extract part of data from this file but save it as an excel
file.
The data in this excel file will be imported into an Access database. The
|
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,...
| |
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...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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
| |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |