Up to Discussions in JExcel API

This Question is Possibly Answered

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)
7 Replies Last post: Mar 13, 2008 3:13 PM by Igor Novikov  
ashish  
ashish
17 posts since
Aug 4, 2007
Currently Being Moderated

Feb 21, 2008 8:35 PM

Running macros under Excel 2007

 

 

 

 

Hi,

 

 

I have a problem running macro enabled Excel file under office 2007 (Windows Vista) with JExcel API(TeamDev). In ofice 2007, excel creates a separate file for macros with the extension .xlsm and JExcel API does not understand to open .xlsm file. Even if you try to open that you get error messages (ScreenShot attached, which does not understand .xlsm and gives the error for .xlsx) and also you get the error "COM Object method returns error code: 0x80004005; E_FAIL (Unspecified error)". If you try to run the .xlsx file you get the error saying the Macros are disabled and even if you go to security and enable macros, still you are not able to run it (Screen Shot attached). Any help running macros under Office 2007 with JExcel API will be appreciated.

 

 

 

-- ASHISH

Attachments:
Igor Novikov TeamDev Ltd.
Igor Novikov
225 posts since
Apr 24, 2006
Currently Being Moderated
1. Mar 4, 2008 7:17 PM in response to: ashish
Re: Running macros under Excel 2007

Hi Ashish,

 

 

We have tested XLSM format parsing using MS Compartibility pack for Office 2003 and found that Workbook instance loads these files successfully. Tomorrow I will check this issue on Office 2007 and let you known the results.

 

Sincerely,

 

Igor Novikov

ashish  
ashish
17 posts since
Aug 4, 2007
Currently Being Moderated
2. Mar 4, 2008 11:26 PM in response to: Igor Novikov
Re: Running macros under Excel 2007

Hi Igor,

 

Here is the attached code for the same, I have created a macro enabled file in Excel 2003 named test.xls and Macro Enabled File Macro.xlsm. When I try to open the either file in Excel 2007 through the code, I get the Exceptions. Exception is :

 

java.lang.IllegalArgumentException: The specified file is not an Excel worbook.

at com.jniwrapper.win32.jexcel.ui.JWorkbook.openWorkbook(_JWorkbook.java:495_)

at com.abwg.client.jexcel.JExcelTest.main(_JExcelTest.java:17_)

 

 

    • Ashish

 

Attachments:
Igor Novikov TeamDev Ltd.
Igor Novikov
225 posts since
Apr 24, 2006
Currently Being Moderated
3. Mar 6, 2008 9:38 PM in response to: ashish
Re: Running macros under Excel 2007

 

Hi Ashish,

 

 

We have found a problem reason. JWorkbook checks BIFF file CLSID before workbook loading. XLS and XLSX formats have equal CLSID but XLSM format CLSID is different.

 

 

We have fixed this issue and tomorrow will upload fixed build on our ftp. When fixed version will be ready for downloading we'll let you known.

 

 

Sincerely,

 

 

Igor Novikov

 

 

 

 

Igor Novikov TeamDev Ltd.
Igor Novikov
225 posts since
Apr 24, 2006
Currently Being Moderated
4. Mar 7, 2008 4:05 PM in response to: ashish
Re: Running macros under Excel 2007

 

Hi Ashish,

 

 

Please find updated JExcel jars on following links:

 

 

ftp://ftp.teamdev.com/updates/jexcel-1.1.819.zip

ftp://ftp.teamdev.com/updates/jexcel-1.1-full.jar

 

 

Please try this solution and let us known the results.

 

 

Sincerely,

 

 

Igor Novikov

 

 

ashish  
ashish
17 posts since
Aug 4, 2007
Currently Being Moderated
5. Mar 7, 2008 7:54 PM in response to: Igor Novikov
Re: Running macros under Excel 2007

Hi Igor,

 

 

Thanks for the new build; the build is stable with Macros and works fine. But still I have a problem opening .xls files with Office 2007 and .xlsx files with Office 2003 (if not, May be compatibility Mode). I still get the same Exception when I try to open the .xls  files with 2007 and vice versa. The sample code remains the same for testing purpose and I have inline comments for testing the same.

 

java.lang.IllegalArgumentException: The specified file is not an Excel workbook.

at com.jniwrapper.win32.jexcel.ui.JWorkbook.openWorkbook(_JWorkbook.java:546_)

at com.abwg.client.jexcel.JExcelTest.main(_JExcelTest.java:21_)

 

Thanks,

-- Ashish

Igor Novikov TeamDev Ltd.
Igor Novikov
225 posts since
Apr 24, 2006
Currently Being Moderated
6. Mar 12, 2008 7:13 PM in response to: ashish
Re: Running macros under Excel 2007

 

Hi Ashish,

 

 

This issue has fixed for XLS file openin with Office 2007. But XLSX files cannot be opened by Office 2003 even with Compartibility pack, because XLSX document format is not recognized by Excel COM object. For this operation you need using file converting in background.

 

 

Tomorrow we plan uploading updated JExcel libraries on our ftp.

 

 

Sincerely,

 

 

Igor Novikov

 

 

Igor Novikov TeamDev Ltd.
Igor Novikov
225 posts since
Apr 24, 2006
Currently Being Moderated
7. Mar 13, 2008 3:13 PM in response to: ashish
Re: Running macros under Excel 2007

 

Hi Ashish,

 

 

Updated JExcel libraries you can find on following link:

 

 

ftp://ftp.teamdev.com/updates/jexcel-1.1.820.zip

ftp://ftp.teamdev.com/updates/jexcel-1.1-full.jar

 

 

Sincerely,

 

 

Igor Novikov

 

 

More Like This

  • Retrieving data ...