News of xlsx4j

Hi Jason,

I am trying to add cell value to the xlsx template that has cell defined as href.

But after adding the cell value and its not coming as HREF.

Once I double click the cell then it becomes HREF.

can you please provide the steps to make the cell as HREF?

Here is snippet of code I am trying .

Cell cell = Context.getsmlObjectFactory().createCell();
try{

cell.setT(STCellType.fromValue(content));

}catch(IllegalArgumentException il)
{
cell.setT(STCellType.STR);
}
//value = ...

I am using docx4j to extract small tables from sheets in a workbook. I am finding the MS SDK and the model in docx4j a bit hard to understand as it seems to have both parts and domain objects all mixed in versus a straight domain model to work with. And it does not appear that one can navigate completely only using the domain model directly. I'm using groovy below:


SpreadsheetMLPackage pkg = (SpreadsheetMLPackage)zip.get(java.nio.file.Files.newInputStream(p)) ...

Does the docX4j jars provided a way to convert an .xlsx file to a .pdf? If so is there example code somewhere?
Thanks
Roger

Hi all,

I can create an Excel Workbook with no problems if I'm creating a cell with "1234" in it.
I used the CreateSimpleSpreadsheet.java example from the following URL:
http://www.docx4java.org/trac/docx4j/browser/trunk/docx4j/src/xlsx4j/java/org/xlsx4j/samples


private static void addContent(WorksheetPart sheet) throws Exception {
// minimal content already present
SheetData sheetData = sheet.getJaxbElement().getSheetData();

// add stuff
Row row = Context.getsmlObjectFactory().createRow();
Cell cell = Context.getsmlObjectFactory().createCell();
cell.setV("1234");
Cell cell2 = Context.getsmlObjectFactory().createCell();
cell2.setV("ABC"); ///// doesn't like this String value, but is OK with ...

When loading and editing an existing xlsx file, is there a way to easily duplicate an existing worksheet? I tried just giving it the same SheetData object, but obviously then changes to one sheet would be reflected in the other sheet as well, which is not what I want.

Hi Jason ,

Can some one you let me know how to remove or hide a sheet from the parsed XLSX template?

I need to remove some of the sheets from the existing template based on some configuration.

I tried as below but no luck ..

WorksheetPart sheet = worksheets.get(Integer.parseInt(sheetArray));

Worksheet ws = sheet.getJaxbElement();
SheetViews sViews =ws.getSheetViews();

List<SheetView> listView = sViews.getSheetView();

for(int i=0; i<listView.size();i++)
{
listView.remove(i);
}



Appreciate your help.

Thanks,
IK

I am doing an XSLT transformation of an XML file, resulting in a new XML file with another layout. I use for this transformation the following Java code:
if (args.length != 3) {
System.err.println("Usage: XML to Excel 2007 or higher "
+ "<input.xml> <input.xsl> <output.xml>");
System.exit(1);
}

String inXML = args;
String inXSL = args;
String outXML = args;

XMLtoXLSX st = new XMLtoXLSX();
try {
st.transform(inXML, inXSL, outXML);
} catch (TransformerConfigurationException e) {
System.err.println("Invalid ...

Hi all

I was just wondering if anyone else was unable to open an xlsx file generated by xlsx4j in Openoffice.

Openoffice states it can http://www.openoffice.org/dev_docs/features/3.2/

When i open the file generated in the sample CreateSimpleSpreadsheet.java I get a blank document.

I have attached the xlsx file

Thank you in advance, any and all help is appreciated.

Harpritt

Hi,

I want to know if it possible with the docx4j api to convert a chart generated by an excel spreadsheet. In fact, I want to re-used that chart within a docx.

Thx in advance for answer.

Hi,

Is it possible to read in a xlsx document, then flatten it, saving the FlatOPC?
I know this is possible with the WordprocessingMLPackage, but based on the parameter types for FlatOpcXmlCreator.getFlatDomDocument(), it doesn't appear that this is supported at the moment?

Cheers,
Andy