예제 #1
0
        private void CreateXlsxReports(XmlDocument xmlReport)
        {
            PayRunIOWebGlobeClass prWG = new PayRunIOWebGlobeClass();
            //Get employer number.
            string coNo = prWG.GetEmployerNumber(xmlReport);
            //Create the Excel workbook
            string outgoingFolder = btnEditSavePDFReports.Text;
            string startDate      = dateStartDate.Text.Replace('/', '.');
            string endDate        = dateEndDate.Text.Replace('/', '.');
            string workBookName;

            PicoXLSX.Workbook workbook = null;
            switch (comboBoxChooseReport.Text)
            {
            case "Pre Report":
                workBookName = outgoingFolder + "\\" + coNo + "_PreReport(" + startDate + "-" + endDate + ").xlsx";
                workbook     = prWG.CreatePreReportWorkbook(xmlReport, workBookName);
                break;

            case "Bottomline Bank Report":
                workBookName = outgoingFolder + "\\" + coNo + "_BottomlineBankReport.xlsx";
                workbook     = prWG.CreateBottomlineReportWorkbook(xmlReport, workBookName);
                break;
            }



            workbook.Save();
        }
예제 #2
0
        /// <summary>
        /// Method to perform a stress test on PixoXLSX with a high amount of random data
        /// </summary>
        /// <param name="filename">filename of the output</param>
        /// <param name="sheetname">name of the worksheet</param>
        /// <param name="rows">Number of rows</param>
        /// <param name="cols">Number of columns</param>
        /// <remarks>The data type is determined per column randomly. In case of strings, random ASCII characters from 1 to 256 characters are written into the cells</remarks>
        public static void StressTest(string filename, string sheetname, int rows, int cols)
        {
            System.Console.WriteLine("Starting performance test - Generating Array...");
            List <List <object> > field = new List <List <object> >();
            List <object>         row;
            List <int>            colTypes = new List <int>();
            DateTime min = new DateTime(1901, 01, 01);
            DateTime max = new DateTime(2100, 01, 01);
            int      j;

            for (int i = 0; i < cols; i++)
            {
                colTypes.Add(Utils.PseudoRandomInteger(1, 6));
            }
            for (int i = 0; i < rows; i++)
            {
                row = new List <object>();
                for (j = 0; j < cols; j++)
                {
                    if (colTypes[j] == 1)
                    {
                        row.Add(Utils.PseduoRandomDate(min, max));
                    }
                    else if (colTypes[j] == 2)
                    {
                        row.Add(Utils.PseudoRandomBool());
                    }
                    else if (colTypes[j] == 3)
                    {
                        row.Add(Utils.PseudoRandomDouble(double.MinValue, double.MaxValue));
                    }
                    else if (colTypes[j] == 4)
                    {
                        row.Add(Utils.PseudoRandomInteger(int.MinValue, int.MaxValue));
                    }
                    else if (colTypes[j] == 5)
                    {
                        row.Add(Utils.PseudoRandomLong(long.MinValue, long.MaxValue));
                    }
                    else if (colTypes[j] == 6)
                    {
                        row.Add(Utils.PseudoRandomString(1, 256));
                    }
                }
                field.Add(row);
            }
            System.Console.WriteLine("Writing cells...");
            PicoXLSX.Workbook  b = new PicoXLSX.Workbook(filename, sheetname);
            PicoXLSX.Worksheet s = b.CurrentWorksheet;
            s.CurrentCellDirection = PicoXLSX.Worksheet.CellDirection.ColumnToColumn;
            for (int i = 0; i < rows; i++)
            {
                for (j = 0; j < cols; j++)
                {
                    s.AddNextCell(field[i][j]);
                }
                s.GoToNextRow();
            }
            System.Console.WriteLine("Saving workbook...");
            b.Save();
            System.Console.WriteLine("Workbook saved");
        }