News of xlsx4j

Hi,
I have a xls template which has drop downs added from developer tool of excel. I need to read the template & populate the data.
Now, when we add a new row in between from excel sheet the drop downs are shifted down, but when i tried from other java API's drop downs did not shift down.
Is it possible to shift drop downs when rows created using xlsx4j API?
Note- Drop downs are ...

I am reading a .xlsx file where each row returns different number of cells. This is because some of the cells are not defined in some rows and these empty/undefined cells are not being returned by row.getC(). Is there a way to configure xlsx4j to return empty cells as null or blank cells ? Something to similar to MissingCellPolicy of Apache POI where we can configure POI to return missing cells as NULL or BLANK.

Hello. I just started learning about xlsx4j. I'm having difficulty get the values from the cells. I have a simple excel file with a few text found in the rows and columns, these are "hello" and "there".
Below is my code:

SpreadsheetMLPackage spread = SpreadsheetMLPackage.load(new java.io.File(excelPath));

WorkbookPart wbPart = spread.getWorkbookPart();
WorksheetPart wsPart = wbPart.getWorksheet(0);

SheetData sheetData = wsPart.getContents().getSheetData();

List<Row> rows = wsPart.getContents().getSheetData().getRow();

for(int i =0; i<rows.size();i++){
List<Cell> cell = rows.get(i).getC();
for(int j=0;j<cell.size();j++){
Cell c = ...

I want to create an image from a spreadsheet in order to insert it into a pptx file (as OLE Object). I know there is already a thread with this topic but I wish to know if there had been some changes since 2011 that makes it easier.

We have used xlsx4j to produce a number of reports which all work fine when we compile our code using Java 6 but not when compiling with Java 7!

We use a number of unusual characters in our reports, and we use code like the following to add them where required (similar code is used for other characters):
public static CTRElt getDoubleAngleWithSpaces()
{
if (doubleAngleWithSpaces == null)
{
doubleAngleWithSpaces = new CTRElt();
Character dbleAngle = ...

Hi All,

I'm trying to parse XSLS file where the B15 cell is DATE and the value is 2015/03/23.

The /xl/worksheets/sheet1.xml file represents it as:

Code: Select all

                <ns2:row r="15" spans="1:5">
                    <ns2:c r="B15" s="31">
                        <ns2:v>40624</ns2:v>
                    </ns2:c>
                </ns2:row>


How to convert "40624" value to "2015/03/23"?

Thank you in advance
Alex

Hello

I am using the following code and its returning empty string.

Code: Select all


    spread = SpreadsheetMLPackage.load(new File(mainFile));
     WorksheetPart sheetpart = (WorksheetPart) spread.getParts().get(new PartName("/xl/worksheets/sheet1.xml"));
    List<Row> rows = sheetpart.getContents().getSheetData().getRow();
    r = rows.get(i);
     for (Cell cr : r.getC())
     {
        if (cr.getF() != null)
        {
         System.out.println(cr.getF().getValue());
        }
       }


Its is returning empty string.

When I write the whole pakage using

Code: Select all

spread.save(new File(output));


All the formulas are retained.

Is this not the correct place to look for ...

Hello

I am trying to delete rows from an excel file using this code

Code: Select all

if (centerList.contains(center))
                   {
                  calculationList.add(new Long(r.getR()));
                  rows.remove(r);
                  i--;
                  total_rows--;
                  old_R--;
                  removal = true;
                  centerList.remove(center);
               }

by rows.remove(r) line.

But this only clears the row.
So I also have to move the cells to one row above after remove, which I do by this.

for (Cell cr : r.getC())
{
String str = cr.getR();
str = str.replaceAll("[0-9]+", new Long(old_R+1).toString());
cr.setR(str);
}
r.setR(old_R+1); ...

Hi!

I'm trying to get the cols from the WorksheetPart but i just can't. It always returns a empty list. Do I need also to create the cols and then associate it to the rows (if yes, how?) or i can just add the cells to the rows and then the sheet will understand that there are news cols on the list?

I'm using the example code with the row.getC().add(createCell("hello world!")); inside a for(int i=0; ...

Hi,
I am trying to insert some headers and footers inside an xlsx file using the library, has anyone done this at all? I would be grateful if you could pinpoint me to a solution or provide some code, not looking for a complex thing, just a string to be insert to an existing xlsx file.

Thanks.