Dear Lily,
If I understand correctly, you are having a website, when you click on an image
in a specific page, the browser (Internet Explorer/Firefox) loads an excel
sheet. You want to load that excel sheet and verify a cell value.
Technically, InternetExplorer/Firefox/WebTest do not know how to open excel
sheet, they just ask windows to open it, and since Microsoft Office Excel is
registered to open such files, the request is sent to it.
Same behavior you can do:
- Load your page with WebTest, find the specific image that should be linked
- Get the URL of the Excel sheet
- Use another library that knows how to open Exel files (Either
http://poi.apache.org or http://sourceforge.net/projects/jacob-project/)
If the library can not load 'URLs', then you have to save the file by WebTest
in binary format and let the library loads it.
Hope that clairifies,
Ahmed
----- Original Message ----
From: "Meng, Lily" <[EMAIL PROTECTED]>
To: "[email protected]" <[email protected]>; Marc Guillemot <[EMAIL
PROTECTED]>
Sent: Wednesday, October 15, 2008 6:24:14 PM
Subject: RE: [Webtest] invoke excel file
Hi Marc,
I believe the excel sheet is created on the fly. I talked to the developer, and
all he could do now is to add an id for the image that I click, which generates
the excel sheet.
In that case how should I invoke it and verify the cell value?
~Lily
