Beispiel #1
0
 public static void RowsToExcel(List <List <string> > rows, string outExcelFileName)
 {
     ExcelAutomate.RowsToExcelFile(rows, outExcelFileName);
 }
Beispiel #2
0
        static void Main(string[] args)
        {
            //Defines supported arguments
            var supportedArgs = new List <SimpleArg>
            {
                new SimpleArg
                {
                    Name                    = "-filename",
                    IsSwitch                = false,
                    Required                = true,
                    DefaultValue            = null,
                    ArgType                 = SimpleArgType.ExistingFilename,
                    ExampleValuePlaceholder = "excelfilename",
                    Description             = "Required. The Microsoft Excel file name"
                },
                new SimpleArg
                {
                    Name                    = "-outfile",
                    IsSwitch                = false,
                    Required                = false,
                    DefaultValue            = null,
                    ArgType                 = SimpleArgType.String,
                    ExampleValuePlaceholder = "outputfilename",
                    Description             = "Optional. Output file. Defaults to [excelfilename] with format specific extension appended."
                },
                new SimpleArg
                {
                    Name                    = "-format",
                    IsSwitch                = false,
                    Required                = false,
                    DefaultValue            = "html",
                    ArgType                 = SimpleArgType.ValueRange,
                    ExampleValuePlaceholder = "html|wikitable|jsonsobjects|jsonarrays|excel",
                    Description             = "Optional. Output file format [html|wikitable|jsonsobjects|jsonarrays|excel]. Defaults to html.",
                    ValueRange              = { "html", "wikitable", "jsonsobjects", "jsonarrays", "excel" }
                },
                new SimpleArg
                {
                    Name                    = "-worksheet",
                    IsSwitch                = false,
                    Required                = false,
                    DefaultValue            = 1,
                    ArgType                 = SimpleArgType.Integer,
                    ExampleValuePlaceholder = "1-n",
                    Description             = "Optional. A one-based index of the worksheet to export data from. Defaults to 1."
                },
                new SimpleArg
                {
                    Name                    = "-range",
                    IsSwitch                = false,
                    Required                = false,
                    DefaultValue            = null,
                    ArgType                 = SimpleArgType.ExcelRange,
                    ExampleValuePlaceholder = "excelrange",
                    Description             = "Optional. Excel cell range to export. e.g. A12:C23. Defaults to the worksheet's used extents."
                }
            };
            SimpleArgParser parser;

            try
            {
                //Parse and validate arguments
                parser = Utils.GetArguments(supportedArgs, args);

                if (parser == null)
                {
                    Console.WriteLine(String.Empty);
                    SimpleArgParser.ShowUsage(supportedArgs);
                    return;
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(String.Empty);
                Console.WriteLine($"Error: {ex.Message}");
                SimpleArgParser.ShowUsage(supportedArgs);
                return;
            }

            //Read excel file
            var rows = ExcelAutomate.ReadExcelRows(parser.ParsedArguments["-filename"],
                                                   out ResultCode rc,
                                                   out string resultDesc,
                                                   parser.ParsedArguments["-worksheet"],
                                                   parser.ParsedArguments.ContainsKey("-range") ? parser.ParsedArguments["-range"] : null);

            if (rc == ResultCode.ErrorOpeningFile)
            {
                Console.WriteLine($"ErrorOpeningFile: {resultDesc}");
                return;
            }

            //Produce output
            Utils.GenerateOutputFile(parser.ParsedArguments["-format"],
                                     rows,
                                     parser.ParsedArguments.ContainsKey("-outfile") ? parser.ParsedArguments["-outfile"] : null);
        }