.ods spreadsheet to JTable

Question

How can I view a sheet from .ods file in JTable? I'm using odftoolkit simple api and that's how I open the file

      String filepath;
      if (openfile.showOpenDialog(null) == JFileChooser.APPROVE_OPTION) {
        filepath = openfile.getSelectedFile().getAbsolutePath();
        try {
            doc = SpreadsheetDocument.loadDocument(filepath);
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null,
                    Locale.getString("fileError.message"),
                    Locale.getString("fileError.title"),
                    JOptionPane.ERROR_MESSAGE);
            return;
        }

At this time I get every row with doc.getTableList().get(0).getRowList(). How could I turn every row into array?

What type does `doc.getTableList().get(0).getRowList()` return? I'm pretty sure it provides some method that will let you make an array of it. — MightyPork, Aug 05 '13 at 19:54
`getRowList()` returns a list of `Row` and I found no useful method in `Row` class. Maybe I'm stupid, maybe not ;D Sure there is. No, I've just googled a little bit. — LivingSilver94, Aug 05 '13 at 19:57
read Oracle tutorial, How to use Tables part Creating a Table Model — mKorbel, Aug 05 '13 at 20:28

score 2 · Accepted Answer · edited May 23 '17 at 11:56

2

How could I turn every row into array?

Don't. Instead, build a TableModel that implements the essential methods, as shown here, using the methods provided by the ODF API.

@Override
public String getColumnName(int col) {…}

@Override
public int getColumnCount() {…}

@Override
public int getRowCount() {…}

@Override
public Object getValueAt(int row, int col) {…}

edited May 23 '17 at 11:56

Community

1
1

answered Aug 05 '13 at 20:47

trashgod

203,806
29
246
1,045

Sounds complicate to me. Will try and report some info :) – LivingSilver94 Aug 06 '13 at 11:51

.ods spreadsheet to JTable

1 Answers1