コード例 #1
0
        private void Btn_GetExcelCellValue_Click(object sender, EventArgs e)
        {
            string excelLocation = tbo_CurrentExcelFile.Text;

            AppendTo_ExcelLog(Helper_Excel.XLGetCellValue(excelLocation, "Sheet1", "A1"));
            AppendTo_ExcelLog(Helper_Excel.XLGetCellValue(excelLocation, "Sheet1", "C4"));
        }
コード例 #2
0
        private void Btn_AddExcelSheets_Click(object sender, EventArgs e)
        {
            string excelLocation = tbo_CurrentExcelFile.Text;

            for (int i = 0; i < 3; i++)
            {
                Helper_Excel.InsertWorksheet(excelLocation);
            }
        }
コード例 #3
0
 private void Btn_WriteInExcelCell_Click(object sender, EventArgs e)
 {
     if (string.IsNullOrWhiteSpace(tbo_CurrentExcelFile.Text) == false)
     {
         string excelLocation = tbo_CurrentExcelFile.Text;
         AppendTo_ExcelLog(Helper_Excel.XLInsertTextIntoCell(excelLocation, "Sheet1", "A1", "Hello There"));
         AppendTo_ExcelLog(Helper_Excel.XLInsertNumberIntoCell(excelLocation, "Sheet1", "C4", 420));
     }
     else
     {
         Tbo_ExcelLog.Text += "Pick an Excel File!";
     }
 }
コード例 #4
0
        private void Btn_CreateEmptyExcelFile_Click(object sender, EventArgs e)
        {
            using (FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog())
            {
                //navigate to a folder. If the user input is "OK" ..Continue operation
                if (folderBrowserDialog.ShowDialog() == DialogResult.OK)
                {
                    string ExcelName_01 = "ExcelExemple_01.xlsx";
                    string ExcelName_02 = "ExcelExemple_02.xlsx";
                    string folderPath   = folderBrowserDialog.SelectedPath;
                    Helper_Excel.XLCreateEmptyFile(ExcelName_01, folderPath);
                    Helper_Excel.XLCreateEmptyFile_version2(ExcelName_02, folderPath);

                    //keep the location of one of the Excel files for future testing
                    tbo_CurrentExcelFile.Text = folderPath + ExcelName_01;
                }
            }
        }
コード例 #5
0
        private void Btn_CreateExcelFileTableFormattedCells_Click(object sender, EventArgs e)
        {
            #region Creating some objects to write in Excel

            List <Employee> employees_List = new List <Employee>();
            Employee        employee1      = new Employee()
            {
                FirstName = "Arakida",
                LastName  = "Moritake",
                Age       = 30,
                HireDate  = DateTime.Now
            };
            Employee employee2 = new Employee()
            {
                FirstName = "Petrescu",
                LastName  = "Camil",
                Age       = 30,
                HireDate  = DateTime.Now.AddDays(-100D)
            };

            employees_List.Add(employee1);
            employees_List.Add(employee2);

            #endregion
            #region Create path of in User\MyDocuments\OXMLTesting

            string path       = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
            string foldername = "OXMLTesting";
            string fullPath   = System.IO.Path.Combine(path, foldername);

            #endregion
            #region Create the Excel File with the objects

            Helper_Excel helper_Excel = new Helper_Excel();
            helper_Excel.CreateExcelFile(employees_List, fullPath);
            AppendTo_ExcelLog($"Excel Created in {fullPath}");

            #endregion
        }
コード例 #6
0
        private void Btn_GetExcelSheetsNames_Click(object sender, EventArgs e)
        {
            string excelLocation = tbo_CurrentExcelFile.Text;

            AppendTo_ExcelLog(Helper_Excel.GetAllExcelSheetsName(excelLocation));
        }