Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Multiple spreadsheets excel cannot open in ipad
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Multiple spreadsheets excel cannot open in ipad
 Login/Join
 
Gold member
posted
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,


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
I guess that is because the file is in fact an MHT file (Single page web archive).


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6136 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Waz,

Thank you for your reply!

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

Shirley


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
"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.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
How do I make sure an iPad can open exl2k file that produce by webfocus?


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Can you check to see what file types the xls program on iPad reads ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6136 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Shirely,

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

David


David

WebFOCUS 8.1.05M (dev, test & prod); all output types
 
Posts: 8 | Registered: June 01, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
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


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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


Webfocus 8.0.7 on Windows
 
Posts: 176 | Location: Ohio | Registered: October 26, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi CLH,

I have not tried the mobile favs app yet.


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
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.


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Multiple spreadsheets excel cannot open in ipad

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.