Has anyone produce a multiple spreadsheets excel output and having issue open in ipad or any mobile devices? In iPad, it gave me "The file format is invalid" error message.

When I create a single spreadsheet excel output, I'm able to open in iPad without any issue.

If I create multiple speadsheets excel using microsoft office, I have no problem opening in iPad.

Any thoughts???

Many thanks!

Shirley

This message has been edited. Last edited by: Kerry,

I guess that is because the file is in fact an MHT file (Single page web archive).

Waz,

Thank you for your reply!

How do I make sure it's an .xls file instead of MHT file?

Shirley

"true" .xls files are created by using EXCEL format (not ELX2K) but then you'll lose a great deal of functionality in WebFOCUS, creating multiple spreadsheets most likely being one of those.

How do I make sure an iPad can open exl2k file that produce by webfocus?

Can you check to see what file types the xls program on iPad reads ?

Shirely,

When you say multiple spreadsheets, are you referring to a compound Excel report with multiple tabs? .

David

Hi dchurch,

Yes, it's a compound excel output format

Here is a simple .fex using CAR as example:

TABLE FILE CAR
PRINT
CAR.ORIGIN.COUNTRY
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.SALES
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K OPEN
ENDSTYLE
END

TABLE FILE CAR
PRINT
CAR.ORIGIN.COUNTRY
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.SALES
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K CLOSE
END

quote:

Originally posted by dchurch:
Shirely,

When you say multiple spreadsheets, are you referring to a compound Excel report with multiple tabs? .

David

Hi,

Have you tried the mobile favs app ? Though it does require a server piece.

It's the compound reports the iPad seems to have issues with.

I haven't tried the ones with table of contents yet and having each part go to a different tab. However a report sent to the iPad in excel format that is not a compound report works fine.

Crystal

Hi CLH,

I have not tried the mobile favs app yet.

Even though this case is closed, but after several server upgrades and trial and errors, here are some of the updates I thought might be interested to know in case anyone else comes across this situation.

1. Multiple spreadsheets excel2k format will not work on any mobile devices. However, there's a work around I've found if only using report caster. The workaround is using a vbscript in the .fex to open and resave as true microsoft excel format(see this post for the vbscript). Then in report caster, use the file task to grab that excel file from server for distribution.

2. If you have wf server version 7.703M or newer with wf client hotfix6, report can be save as exl07 format, which can be open in any mobile devices without using the vbscript. However, there are some drawbacks with exl07 format, such as template feature, bursting in report caster and few others.

Mobile faves won't help resolve in this case.