ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   web interface for excel (https://www.excelbanter.com/excel-programming/330103-web-interface-excel.html)

Gixxer_J_97[_2_]

web interface for excel
 
hi all,

is there a way to have a web page (html or php) read portions of an excel
file?

if anyone has an example on how to read a cell from an .xls file into a text
field for web display, or a range of cells into a dropdown box - i'd greatly
appreciate it!

and secondly - is it possible to do the reverse - write to the file - or
call the macros in the file?

tia!

J

Tim Williams

web interface for excel
 
You can "push" data from Excel into IE using automation, but unless
you're running very low security settings you will not be able to
automate Excel from within IE.

What exactly do you want to do?

Tim


"Gixxer_J_97" wrote in message
...
hi all,

is there a way to have a web page (html or php) read portions of an
excel
file?

if anyone has an example on how to read a cell from an .xls file
into a text
field for web display, or a range of cells into a dropdown box - i'd
greatly
appreciate it!

and secondly - is it possible to do the reverse - write to the
file - or
call the macros in the file?

tia!

J




Gixxer_J_97[_2_]

web interface for excel
 
Hi Tim!

i have an excel book that has all kinds of information - customer info,
order history, inventory levels, etc etc

i would like to be able to give our export manager (in another country)
certain information when she needs it - i have a summary page already created
in this workbook that would be sufficient - i also have a copy of this sheet
that works independently of the workbook - but needs to have access to it.

i thought if i could use a web interface to give access to read/interact
this would solve the problems

i can e-mail the 2nd book, but it will #VALUE out when it cannot find the
master book

suggestions?

"Tim Williams" wrote:

You can "push" data from Excel into IE using automation, but unless
you're running very low security settings you will not be able to
automate Excel from within IE.

What exactly do you want to do?

Tim


"Gixxer_J_97" wrote in message
...
hi all,

is there a way to have a web page (html or php) read portions of an
excel
file?

if anyone has an example on how to read a cell from an .xls file
into a text
field for web display, or a range of cells into a dropdown box - i'd
greatly
appreciate it!

and secondly - is it possible to do the reverse - write to the
file - or
call the macros in the file?

tia!

J






All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com