0

I create a plugin for a game and some of the data I use to create my plugin DB is generated in excel. What I am doing so far is generating the table in excel and use Copy-Paste to my C#. e.g. I copy this: enter image description here

And paste it in my code here:

 CommHelper.Creator(vaProxy, "AWACSDeclare", "Q", 1, "2", "declare", commExpHash);
 CommHelper.Creator(vaProxy, "AWACSRequestHelp", "Q", 1, "3", "request help", commExpHash);
 CommHelper.Creator(vaProxy, "AWACSWilco", "Q", 1, "4", "wilco", commExpHash);
 CommHelper.Creator(vaProxy, "AWACSUnable", "Q", 1, "5", "unable", commExpHash);

At the beginning I only had a few commands, but now I have many more. What is the bets approach to achieve this? I was thinking of saving the entire excel tab and add the actual missing (headers and footer) but this may cause sync issues in VS as I am creating the file externally.

dandan
  • 509
  • 3
  • 8
  • 21
  • Does this answer your question? [How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?](https://stackoverflow.com/questions/151005/how-do-i-create-an-excel-xls-and-xlsx-file-in-c-sharp-without-installing-mic) – touchofevil Jun 09 '20 at 05:59
  • No, I do not want to create an excel sheet. I want to import data from it. – dandan Jun 09 '20 at 06:16

0 Answers0