private void newNToolStripMenuItem_Click(object sender, EventArgs e)
 {
     //test create xls file
     string file = "C:\\newdoc.xls";
     Workbook workbook = new Workbook();
     Worksheet worksheet = new Worksheet("First Sheet");
     worksheet.Cells[0, 1] = new Cell((short)1);
     worksheet.Cells[2, 0] = new Cell(2.8);
     worksheet.Cells[3, 3] = new Cell((decimal)3.45);
     worksheet.Cells[2, 2] = new Cell("Text string");
     worksheet.Cells[2, 4] = new Cell("Second string");
     worksheet.Cells[4, 0] = new Cell(32764.5, "#,##0.00");
     worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY\-MM\-DD");
     worksheet.Cells.ColumnWidth[0, 1] = 3000;
     //Picture pic = new Picture();
     //pic.Image = Excel.Image.FromFile("C:\\DelBreakpoint.png");
     //pic.TopLeftCorner = new CellAnchor(5, 1, 0, 0);
     //pic.BottomRightCorner = new CellAnchor(12, 5, 592, 243);
     //worksheet.AddPicture(pic);
     workbook.Worksheets.Add(worksheet);
     workbook.Save(file);
     //open created file
     doc = CompoundDocument.Open(file);
     IsOpened = true;
     PopulateTreeview(file);
 }

        public void WriteLongTextTest()
        {
            int longTextLength = 50000;

            StringBuilder builder = new StringBuilder(longTextLength);
            for (int i = 0; i < longTextLength; i++)
                builder.Append('A');

            string longText = builder.ToString();

            string tempFilePath = Path.GetTempFileName();
            {
                Workbook workbook = new Workbook();
                Worksheet worksheet = new Worksheet("Test");
                worksheet.Cells[0, 0] = new Cell(longText);

                workbook.Worksheets.Add(worksheet);
                workbook.Save(tempFilePath);
            }

            {
                Workbook workbook = Workbook.Load(tempFilePath);
                Assert.AreEqual(longText, workbook.Worksheets[0].Cells[0, 0].Value);
            }
        }

        public Worksheet EnteteOPR11Ligne2(Worksheet worksheet)
        {
            worksheet.Cells[1, 0] = new Cell("OPR 11");
            worksheet.Cells[1, 1] = new Cell("OT Report");

            return worksheet;
        }

        public Worksheet EnteteOPR17Ligne2(Worksheet worksheet)
        {
            worksheet.Cells[1, 0] = new Cell("OPR 17");
            worksheet.Cells[1, 1] = new Cell("Payroll summary");

            return worksheet;
        }

    public static void ExportToExcel(DataSet dataSet, string outputPath)
    {
        Workbook workbook = new Workbook();
        foreach (DataTable dt in dataSet.Tables)
        {
            Worksheet worksheet = new Worksheet(dt.TableName);
            for (int i = 0; i < dt.Columns.Count; i++)
            {
                // Add column header
                worksheet.Cells[0, i] = new Cell(dt.Columns[i].ColumnName);

                // Populate row data
                for (int j = 0; j < dt.Rows.Count; j++)
                {
                    if (dt.Rows[j][i] == DBNull.Value)
                        worksheet.Cells[j + 1, i] = new Cell(string.Empty);
                    else
                        if (dt.Columns[i].DataType == typeof(DateTime))
                        {
                            worksheet.Cells[j + 1, i] = new Cell(dt.Rows[j][i], new CellFormat(CellFormatType.Date, "DD.MM.YYYY"));
                        }
                        else
                            worksheet.Cells[j + 1, i] = new Cell(dt.Rows[j][i]);
                }
            }
            workbook.Worksheets.Add(worksheet);
        }
        workbook.Save(outputPath);
    }

        public Worksheet EnteteOPR15Ligne2(Worksheet worksheet)
        {
            worksheet.Cells[1, 0] = new Cell("OPR 15");
            worksheet.Cells[1, 1] = new Cell("FINANCIAL REPORT");

            return worksheet;
        }

        public void SimpleMultipleSheetTest()
        {
            int worksheetToCreate = 10;

            string tempFilePath = Path.GetTempFileName();
            {
                Workbook workbook = new Workbook();
                for (int i = 0; i < worksheetToCreate; i++)
                {
                    Worksheet worksheetWrite2 = new Worksheet(String.Format("Sheet {0}", i));
                    workbook.Worksheets.Add(worksheetWrite2);
                }

                workbook.Save(tempFilePath);
            }

            {
                Workbook workbook = Workbook.Load(tempFilePath);

                Assert.AreEqual(worksheetToCreate, workbook.Worksheets.Count);
                for (int i = 0; i < worksheetToCreate; i++)
                {
                    Assert.AreEqual(String.Format("Sheet {0}", i), workbook.Worksheets[i].Name);
                }
            }
        }

     public void EcritureC(int idSoc, Worksheet worksheet, int MoisPe, int AnneePe)
     {
 //        if (idSoc == 2)
 //        {
             worksheet = entete.EnteteSVRLigne14(worksheet, idSoc, MoisPe, AnneePe);
 //        }
     }

        public static void excel_batch_template(WSProject p)
        {
            string file = @"C:\Users\WindSim\Desktop\Francesco\WindSim_Projects\MoninObukhov\batch.xls";
            Workbook workbook = new Workbook();
            Worksheet worksheet = new Worksheet("Batch Data");

            // this cycle add some null cells because when on Windows 7 Office need at least 6000byte files.
            //----------------------------------------------
            for (var k = 0; k < 200; k++)
                worksheet.Cells[k, 0] = new Cell(null);
            // ---------------------------------------------

            XmlReader reader = XmlReader.Create(p.file.FullName);
            int i = 0;
            while (reader.Read())
            {
                if (reader.NodeType == XmlNodeType.EndElement)
                {
                    worksheet.Cells[i, 0] = new Cell(reader.Name);
                    if (reader.Read())
                    {
                        worksheet.Cells[i, 1] = new Cell(reader.Value.Trim());

                    }
                    i++;
                }
            }

            workbook.Worksheets.Add(worksheet);

            workbook.Save(file);
        }

        //private DocumentService documentService =new DocumentService();
        public static string FileGen(string fileName,List<List<string>> sheet )
        {
            if (!Directory.Exists(Constants.ImportTempFolder))
                Directory.CreateDirectory(Constants.ImportTempFolder);
            string file = Constants.ImportTempFolder+fileName;
            if (File.Exists(file))
            {
                try
                {
                    File.Delete(file);
                }
                catch (Exception)
                {

                    return null;
                }
            }
            Workbook workbook = new Workbook();
            Worksheet worksheet = new Worksheet("First Sheet");
            for (int row=0; row<sheet.Count;row++)
            {
                for (var col = 0; col < sheet[row].Count;col++ )
                {
                    worksheet.Cells[row, col] = new Cell(sheet[row][col]);
                }
            }
            workbook.Worksheets.Add(worksheet);
            workbook.Save(file);

            return file;
        }

 public Worksheet EnteteSRFLigne2(Worksheet worksheet,string NomSoc,string Date1,string Date2,string CodeSoc,bool PeNormal,bool Bonus,string DatePe)
 {
     worksheet.Cells[1, 0] = new Cell("D0");
     worksheet.Cells[1, 1] = new Cell("UTF8");
     worksheet.Cells[1, 2] = new Cell((DateTime.Now.ToString().Substring(0,10)));
     string HeureMin = ExtraireHeure(DateTime.Now.Hour.ToString(),DateTime.Now.Minute.ToString(),DateTime.Now.Second.ToString());
     worksheet.Cells[1, 3] = new Cell(HeureMin);
     worksheet.Cells[1, 4] = new Cell("SRF");
     worksheet.Cells[1, 5] = new Cell("M2.0.2.0");
     worksheet.Cells[1, 6] = new Cell("F1.0.0");
     worksheet.Cells[1, 7] = new Cell("ABC");
     worksheet.Cells[1, 8] = new Cell("TN");
     worksheet.Cells[1, 9] = new Cell(CodeSoc);
     worksheet.Cells[1, 10] = new Cell(NomSoc);
     worksheet.Cells[1, 11] = new Cell("TN");
     worksheet.Cells[1, 12] = new Cell("TND");
     worksheet.Cells[1, 13] = new Cell(DatePe);
     worksheet.Cells[1, 14] = new Cell(Date1);
     worksheet.Cells[1, 15] = new Cell(Date2);
     worksheet.Cells[1, 16] = new Cell(1);
     int leMois = int.Parse(Date1.Substring(3, 2));
     string MoisC = service.NomDuMoisEnglish(leMois);
     string Year = Date1.Substring(6,4);
     worksheet.Cells[1, 17] = new Cell("payroll "+MoisC+" "+Year);
     string TypePay = TypedePayroll(PeNormal, Bonus);
     worksheet.Cells[1, 18] = new Cell(TypePay);
     worksheet.Cells[1, 19] = new Cell(0);       
     return worksheet;
 }

        private void writeHeader(string filename)
        {
            Workbook workbook;
            if (File.Exists(filename))
                workbook = Workbook.Load(filename);
            else
                workbook = new Workbook();

            Worksheet akWorksheet = null;
            foreach (Worksheet worksheet in workbook.Worksheets)
            {
                if (worksheet.Name == TableName)
                    akWorksheet = worksheet;
            }
            if (akWorksheet == null)
            {
                akWorksheet = new Worksheet(TableName);
                workbook.Worksheets.Add(akWorksheet);
            }

            int n = 0;
            foreach (DatasetConfigRow myFeld in datasetConfig.DatasetConfigRows)
            {
                akWorksheet.Cells[0, n] = new Cell(myFeld.DatabaseField);
                n++;
            }

            workbook.Save(filename);
        }

        public Worksheet EnteteOPR8Ligne1(Worksheet worksheet,string NomSoc)
        {
            worksheet.Cells[0, 0] = new Cell("Client");
            worksheet.Cells[0, 1] = new Cell(NomSoc);

            return worksheet;
        }

        public Worksheet EnteteOPR8Ligne2(Worksheet worksheet)
        {
            worksheet.Cells[1, 0] = new Cell("OPR 08");
            worksheet.Cells[1, 1] = new Cell("Comparatif Payement par Virement");

            return worksheet;
        }

        public CursorExcel2003(byte[] data)
        {
            var wb = Workbook.Load(new MemoryStream(data));
            if (wb == null || wb.Worksheets.Count <= 0)
                throw new ReportFormatException("Data was not recognized as Excel2003");

            _worksheet = wb.Worksheets[0];
        }

 public ExcelAngleData()
 {
     worksheet = new Worksheet("angles");
     PhoneAngletimer = new DispatcherTimer();
     //samplerate for saving phone angles can changed here.
     PhoneAngletimer.Interval = TimeSpan.FromMilliseconds(200);
     PhoneAngletimer.Tick += PhoneAngletimer_Tick;
 }

 public Worksheet EnteteSVRLigne8(Worksheet worksheet,string Date1,string Date2)
 {
     string DT1 = form.LA_DATE_ADP(Date1);
     string DT2 = form.LA_DATE_ADP(Date2);
     worksheet.Cells[7, 0] = new Cell("Pay Cycle");
     worksheet.Cells[7, 1] = new Cell(DT1+"-"+DT2);
     return worksheet;
 }

        public static void Create(string filename)
        {
            Filename = filename;
            workbook = new Workbook();
            worksheet = new Worksheet("Output");

            for (int i = 0; i < 100; i++)
                worksheet.Cells[i, 0] = new Cell("");
        }

 public static void AddParticipantToWorksheet(Worksheet ws, int row, IParticipant p)
 {
     string participantData = GetParticipantData(p, null);
     string[] participantValues = participantData.Split(';');
     for (int i = 0; i < participantValues.Length; i++)
     {
         ws.Cells[row, i] = new Cell(participantValues[i]);
     }
 }

 public static Worksheet Decode(Workbook book, Stream stream, SharedResource sharedResource)
 {
     Worksheet sheet = new Worksheet();
     sheet.Book = book;
     List<Record> records = ReadRecords(stream, out sheet.Drawing);
     sheet.Cells = PopulateCells(records, sharedResource);
     sheet.Book.Records.AddRange(records);
     return sheet;
 }