Q
Problem solve Get help with specific problems with your technologies, process and projects.

Display from my Web page an an online link using Excel

I have a predefined Excel file. I have also developed an Intranet Web-enabled solution using Domino. But, I need to display the Excel file from my Web page as an online link with the excel file.

a. The Excel file must be opened from the Web. It is a shared file resided in the server. The data is updated from another Notes DB via agent.
b. If someone updates the data in Excel, the Web version of the file needs to be updated instantly as an online link. The Excel file also contains lots of graph.
c. What tool should I use to create chart from Notes data?
d. In Excel by running a Web query we can collect data, but can I pass the query string from Lotus Script in run time? Normally it is a pre-defined query.
I'm not completely sure I understand what you mean by "online link." I assume you mean a standard hypertext link created with an anchor tag ( &ltA> ). Does item b. mean that when a user is viewing the Excel file, if changes are made on the back-end, you want to update the display of the file in the user's browser? If so, that will be very tricky if not impossible. For a charting tool, you might look at Crystal Reports, or maybe export the data and use Excel. I don't really understand item d.

This was last published in May 2002

Dig Deeper on Domino Resources - Part 3

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close