News of xlsx4j

Hi,

im trying to replace variables in a simple XSLX file (attached) but I'm getting a UnmarshalException. I'm using Word 2010 on Win 8.1. Please advise.

Code:

File inputFile = new File("C:/Temp/sample2.xlsx");
File outputFile = new File("C:/Temp/sample2_output.xlsx");

SpreadsheetMLPackage opcPackagepkg = SpreadsheetMLPackage.load(inputFile);
WorksheetPart sheet = (WorksheetPart) opcPackagepkg.getParts().get(new PartName("/xl/worksheets/sheet1.xml"));

HashMap<String, String> mappings = new HashMap<String, String>();
mappings.put("title1", "This is a title");

sheet.variableReplace(mappings);
opcPackagepkg.save(outputFile);


Log and stacktrace:

INFO org.xlsx4j.jaxb.Context - Using JAXB Reference Implementation ...

I am trying to parse xlsx file , this file has lot of sheets , using SpreadsheetMLPackage.load.getWorkbookPart () I can get WorkbookPart, this has List of sheets, I want to get WorksheetPart for each Sheet to get the sheetdata.Please advice me how.

Code: Select all

SpreadsheetMLPackage xlsxPkg = SpreadsheetMLPackage.load(new java.io.File(inputfilepath));      
      
      
      WorkbookPart workbookPart= xlsxPkg.getWorkbookPart();
      workbookPart.getContents().getSheets().getSheet().forEach((Sheet  sheet)->{
         System.out.println(sheet.getName()+" "+sheet.getId());
      });

How can I set border, width and bold font for custom cells?

If I have an xlsx file with header (there are complex headers with merged cols) can I use it as template in xlsx4j? Is there instructions/docs somewhere describing how to do this?
I need do upload document header from existing file and then add some rows to it with xlsx4j

Hi,

I have generated

test.xlsx

with xlsx4j , but if I try to print it, Excel crashes and restarts. This is the Error message without information :

printError.png

What did I do wrong?

Regards, Nadeo

I've searched for xlsx4j examples for this, but can't find anything other than this post, which is not a simple example
http://www.docx4java.org/forums/xlsx-java-f15/adding-style-information-crashes-excel-t647.html

I see how the styles are created and added to the workbook, but I can't figure out how you set a style on a cell. I've used the online code generator with a simple spreadsheet I created, but since it doesn't output the code for the entire xlsx file at once, I can't ...

Warning: I have posted this on StackOverflow as well about 4 days ago but it has gotten no responses so I thought I would try my luck on this forum. I will update it with any responses I may get here. My question:

I am trying to add a digital signature to an xlsx file... Can't seem to find any resources for this (other than adding signatures to literal/regular xml files). Is this possible with ...

Hi!

In 3.0.1 you can do something like this

Code: Select all

        SpreadsheetMLPackage pkg = (SpreadsheetMLPackage)OpcPackage.load(getClass().getResourceAsStream("gr25.xlsx"));
        Worksheet workSheet = pkg.getWorkbookPart().getWorksheet(0).getContents();


Can the same be achieved with version 2.8.1?

Seems to have a compil error since the commit :

commit ba59b54f7cfbaaeee7463e6052132ca4c76f423e
Author: Jason Harrop <jason@plutext.org> 2014-01-16 22:40:18
Committer: Jason Harrop <jason@plutext.org> 2014-01-16 22:40:18
Parent: 40056bc4309d7d1bf369e72899505eab5c2b1a83 (Convenience method getSharedStrings())
Branches: master, origin/master

New method: getWorksheet(int index)

Did you don't forget to add the org.xlsx4j.exceptions.Xlsx4jException package ?

PS : I am a noobie on git, and I just want to have the last release sources (3.0.0) > How can I do ?

Hi Jason,
I am trying to add hyperlinks for url and docx links in xlsx just like the attachment file

but I can't find any sample java source code

so, could you send me a sample source code about how to add hyperlinks for cell value,

my email is :dcjhfut2008@126.com

thank you very much.

Best regards!