How can I transfer data from a 2-dimensional array to an Excel spreadsheet in C#?

Question

.NET

Hello.
For example, there is such a 2-dimensional array:

string [,] array = {
                             { "кошка", "стрекоза", "собака", "слон" },
                             { "бабочка", "гусеница", "бегемот", "обезьяна" },
                             { "жираф", "синица", "воробей", "волк" }
                             { "жук", "муравей", "снеговик", "медведь" }
                             { "ящерица", "енот", "заяц", "лиса" }
                           };

How can I transfer data from this 2-dimensional array to an Excel table (that is, to an .xlsx file) so that this tabular data can then be processed in Excel?
PS At the same time, the table file (.xlsx) has not yet been created.

Answer 1

The question needs clarification... do you want to serialize some data into an xls file? There is a crutch way, but it works - generate an html table with this data and save it to a file with the xls extension. If you want something more tricky - https://msdn.microsoft.com/en-us/library/ms173186(... Well, here's a suitable article

Answer 2

The simplest and most reliable solution is to export data to CSV , Excel can open files in this format (you can import data from them into an existing workbook)