You can use a library called ExcelLibrary. It's a free, open source library posted on Google Code:

ExcelLibrary

This looks to be a port of the PHP ExcelWriter that you mentioned above. It will not write to the new .xlsx format yet, but they are working on adding that functionality in.

It's very simple, small and easy to use. Plus it has a DataSetHelper that lets you use DataSets and DataTables to easily work with Excel data.

ExcelLibrary seems to still only work for the older Excel format (.xls files), but may be adding support in the future for newer 2007/2010 formats.

You can also use EPPlus, which works only for Excel 2007/2010 format files (.xlsx files). There's also NPOI which works with both.

There are a few known bugs with each library as noted in the comments. In all, EPPlus seems to be the best choice as time goes on. It seems to be more actively updated and documented as well.

Also, as noted by @АртёмЦарионов below, EPPlus has support for Pivot Tables and ExcelLibrary may have some support (Pivot table issue in ExcelLibrary)

Here are a couple links for quick reference:

ExcelLibrary - GNU Lesser GPL

EPPlus - GNU (LGPL) - No longer maintained

EPPlus 5 - Polyform Noncommercial - Starting May 2020

NPOI - Apache License

**Here some example code for ExcelLibrary:**

Here is an example taking data from a database and creating a workbook from it. Note that the ExcelLibrary code is the single line at the bottom:

```
//Create the data set and table
DataSet ds = new DataSet("New_DataSet");
DataTable dt = new DataTable("New_DataTable");
//Set the locale for each
ds.Locale = System.Threading.Thread.CurrentThread.CurrentCulture;
dt.Locale = System.Threading.Thread.CurrentThread.CurrentCulture;
//Open a DB connection (in this example with OleDB)
OleDbConnection con = new OleDbConnection(dbConnectionString);
con.Open();
//Create a query and fill the data table with the data from the DB
string sql = "SELECT Whatever FROM MyDBTable;";
OleDbCommand cmd = new OleDbCommand(sql, con);
OleDbDataAdapter adptr = new OleDbDataAdapter();
adptr.SelectCommand = cmd;
adptr.Fill(dt);
con.Close();
//Add the table to the data set
ds.Tables.Add(dt);
//Here's the easy part. Create the Excel worksheet from the data set
ExcelLibrary.DataSetHelper.CreateWorkbook("MyExcelFile.xls", ds);
```

Creating the Excel file is as easy as that. You can also manually create Excel files, but the above functionality is what really impressed me.

**Summary** `ArrayList`

with `ArrayDeque`

are preferable in *many* more use-cases than `LinkedList`

. If you're not sure — just start with `ArrayList`

.

TLDR, in ArrayList accessing an element takes constant time [O(1)] and adding an element takes O(n) time [worst case]. In LinkedList adding an element takes O(n) time and accessing also takes O(n) time but LinkedList uses more memory than ArrayList.

`LinkedList`

and `ArrayList`

are two different implementations of the List interface. `LinkedList`

implements it with a doubly-linked list. `ArrayList`

implements it with a dynamically re-sizing array.

As with standard linked list and array operations, the various methods will have different algorithmic runtimes.

For `LinkedList<E>`

`get(int index)`

is *O(n)* (with *n/4* steps on average), but *O(1)* when `index = 0`

or `index = list.size() - 1`

(in this case, you can also use `getFirst()`

and `getLast()`

). **One of the main benefits of** `LinkedList<E>`

`add(int index, E element)`

is *O(n)* (with *n/4* steps on average), but *O(1)* when `index = 0`

or `index = list.size() - 1`

(in this case, you can also use `addFirst()`

and `addLast()`

/`add()`

). **One of the main benefits of** `LinkedList<E>`

`remove(int index)`

is *O(n)* (with *n/4* steps on average), but *O(1)* when `index = 0`

or `index = list.size() - 1`

(in this case, you can also use `removeFirst()`

and `removeLast()`

). **One of the main benefits of** `LinkedList<E>`

`Iterator.remove()`

is *O(1)*. **One of the main benefits of** `LinkedList<E>`

`ListIterator.add(E element)`

is *O(1)*. **One of the main benefits of** `LinkedList<E>`

^{Note: Many of the operations need n/4 steps on average, constant number of steps in the best case (e.g. index = 0), and n/2 steps in worst case (middle of list)}

For `ArrayList<E>`

`get(int index)`

is *O(1)*. **Main benefit of** `ArrayList<E>`

`add(E element)`

is *O(1)* amortized, but *O(n)* worst-case since the array must be resized and copied
`add(int index, E element)`

is *O(n)* (with *n/2* steps on average)
`remove(int index)`

is *O(n)* (with *n/2* steps on average)
`Iterator.remove()`

is *O(n)* (with *n/2* steps on average)
`ListIterator.add(E element)`

is *O(n)* (with *n/2* steps on average)

^{Note: Many of the operations need n/2 steps on average, constant number of steps in the best case (end of list), n steps in the worst case (start of list)}

`LinkedList<E>`

allows for constant-time insertions or removals *using iterators*, but only sequential access of elements. In other words, you can walk the list forwards or backwards, but finding a position in the list takes time proportional to the size of the list. Javadoc says *"operations that index into the list will traverse the list from the beginning or the end, whichever is closer"*, so those methods are *O(n)* (*n/4* steps) on average, though *O(1)* for `index = 0`

.

`ArrayList<E>`

, on the other hand, allow fast random read access, so you can grab any element in constant time. But adding or removing from anywhere but the end requires shifting all the latter elements over, either to make an opening or fill the gap. Also, if you add more elements than the capacity of the underlying array, a new array (1.5 times the size) is allocated, and the old array is copied to the new one, so adding to an `ArrayList`

is *O(n)* in the worst case but constant on average.

So depending on the operations you intend to do, you should choose the implementations accordingly. Iterating over either kind of List is practically equally cheap. (Iterating over an `ArrayList`

is technically faster, but unless you're doing something really performance-sensitive, you shouldn't worry about this -- they're both constants.)

The main benefits of using a `LinkedList`

arise when you re-use existing iterators to insert and remove elements. These operations can then be done in *O(1)* by changing the list locally only. In an array list, the remainder of the array needs to be *moved* (i.e. copied). On the other side, seeking in a `LinkedList`

means following the links in *O(n)* (*n/2* steps) for worst case, whereas in an `ArrayList`

the desired position can be computed mathematically and accessed in *O(1)*.

Another benefit of using a `LinkedList`

arises when you add or remove from the head of the list, since those operations are *O(1)*, while they are *O(n)* for `ArrayList`

. Note that `ArrayDeque`

may be a good alternative to `LinkedList`

for adding and removing from the head, but it is not a `List`

.

Also, if you have large lists, keep in mind that memory usage is also different. Each element of a `LinkedList`

has more overhead since pointers to the next and previous elements are also stored. `ArrayLists`

don't have this overhead. However, `ArrayLists`

take up as much memory as is allocated for the capacity, regardless of whether elements have actually been added.

The default initial capacity of an `ArrayList`

is pretty small (10 from Java 1.4 - 1.8). But since the underlying implementation is an array, the array must be resized if you add a lot of elements. To avoid the high cost of resizing when you know you're going to add a lot of elements, construct the `ArrayList`

with a higher initial capacity.

If the data structures perspective is used to understand the two structures, a LinkedList is basically a sequential data structure which contains a head Node. The Node is a wrapper for two components : a value of type T [accepted through generics] and another reference to the Node linked to it. So, we can assert it is a recursive data structure (a Node contains another Node which has another Node and so on...). Addition of elements takes linear time in LinkedList as stated above.

An ArrayList, is a growable array. It is just like a regular array. Under the hood, when an element is added at index i, it creates another array with a size which is 1 greater than previous size (So in general, when n elements are to be added to an ArrayList, a new array of size previous size plus n is created). The elements are then copied from previous array to new one and the elements that are to be added are also placed at the specified indices.

## Best Solution

I am seeing the following situation on Windows 7:

The file in question is "var\log", the absolute path does refer to an existing file that is in a normal subdirectory (not a virtual store). This is seen from the IDE.