Convert Excel Column into String array

Question

I have a column of words in Excel and i want to convert it to a string array, it is a long list and i can't do it manually. How can i do it?

My excel is like:

Car
House
Key
Phone
...

I want my array to be like:

"Car","House","Key","Phone",...

Thanks in advance.

Is this a one-off job or do you want to do that with many different excel files? — Erich Kitzmueller
– Erich Kitzmueller, Commented Aug 25, 2014 at 13:01
Well, just use a formular like =""""&A1&"""," in the second column, then copy-paste that second column into your java source code. — Erich Kitzmueller
– Erich Kitzmueller, Commented Aug 25, 2014 at 13:05
Sure, just mark cell B1, press Ctrl+C, mark B2..B42, press Ctrl+V ... I guess you don't work with Excel that much?!? — Erich Kitzmueller
– Erich Kitzmueller, Commented Aug 25, 2014 at 13:08
Or you just drag the lower right corner (there should be a small black sqare) of B1 downwards... — Erich Kitzmueller
– Erich Kitzmueller, Commented Aug 25, 2014 at 13:10

Saqib · Accepted Answer · 2014-08-25 13:30:55Z

0

Aspose.Cells for Java is your friend here. Use this code to read values of a column into a string array.

ArrayList<String> list = new ArrayList<>();

Workbook workbook = new Workbook("spreadsheet.xlsx");
Worksheet worksheet = workbook.getWorksheets().get("Sheet1");
for (Object o: worksheet.getCells().getRows()) {
    Cell cell = ((Row) o).getCellByIndex(0);
    list.add(cell.getStringValueWithoutFormat());
}

Import classes from com.aspose.cells.*. Enjoy a free temporary license for a limited time before purchasing.

Disclosure: I am a developer at Aspose.

answered Aug 25, 2014 at 13:30

Saqib

916 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rudresh Oza · Accepted Answer · 2024-02-14 10:51:04Z

-1

Try Below mentioned link

Column to string

answered Feb 14, 2024 at 10:51

Rudresh Oza

832 silver badges10 bronze badges

Collectives™ on Stack Overflow

Convert Excel Column into String array

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related