Example #1
0
        /// <summary>
        /// Creates an instance of the application
        /// </summary>
        /// <param name="application">owner application</param>
        /// <param name="ownerAssembly">owner assembly</param>
        public CommonUtils(ExcelApi.Application application, Assembly ownerAssembly) : base(application, ownerAssembly)
        {
            if (null == application)
                throw new ArgumentNullException("application");

            _ownerApplication = application;
        }
 public void Setup()
 {
     excelApi = new ExcelApi();
     excelApi.LoadSheet();
     LaunchFirefox();
     //driver.FindElement(By.LinkText("Add Product")).Click();
     Wait(500);
 }
Example #3
0
 private void Exec(object sender, DoWorkEventArgs e)
 {
     count = 3;
     while (count < rows)
     {
         int val = ExcelApi.readone(count);
         bgWorker.ReportProgress(100 * val / rows);
         count++;
     }
 }
Example #4
0
        public async Task <Schedule> GetSchedule(int groupId, string parity)
        {
            var listRanges = GenerateListRanges(groupId, parity);
            var schedule   = await ExcelApi.GetSchedule(listRanges);

            schedule.GroupId = groupId.ToString();
            schedule.Parity  = parity.ParityConverterExtension();

            return(schedule);
        }
Example #5
0
 public void Refresh()
 {
     this.IsEnabled = true;
     list.Dispatcher.BeginInvoke(
         new Action(() => {
         list.ItemsSource = ExcelApi.GetPokemonList();
         list.Focus();
         list.SelectedIndex = 0;
     }),
         null);
 }
Example #6
0
 public Progress(string filename, RefreshEventHandler delg)
 {
     InitializeComponent();
     RefreshDelg = delg;
     bgWorker    = new BackgroundWorker();
     bgWorker.WorkerReportsProgress      = true;
     bgWorker.WorkerSupportsCancellation = false;
     bgWorker.DoWork             += new DoWorkEventHandler(Exec);
     bgWorker.ProgressChanged    += new ProgressChangedEventHandler(ProgressChanged);
     bgWorker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(WorkCompleted);
     ExcelApi.Init(filename);
     count = 3;
     rows  = ExcelApi.GetRows();
 }
        public void ExcelConvertToPDFTest()
        {
            var apiKey = new Dictionary <string, string>()
            {
                { "AppSecret", "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX" },
                { "AppId", "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX" }
            };

            var config = new Configuration(apiKey: apiKey);

            config.ApiClient = new ApiClient(config);

            var excel  = new ExcelApi(config);
            var result = excel.ExcelConvertToPDF("excel_sample.xlsx", "excel_sample.pdf");

            Assert.IsTrue(result.Contains("excel_sample"));
        }
        public void PdfViewer(Configuration config, string sourceFileName, string sourceFileType, string resultFileName, string resultfileType, int offset, int count)
        {
            var ExcelApi = new ExcelApi(config);

            if (!Directory.Exists(ConfigurationManager.AppSettings["SourcePath"] + "metrics/"))
            {
                Directory.CreateDirectory(ConfigurationManager.AppSettings["SourcePath"] + "metrics/");
            }

            Stream outFileStream = new FileStream(ConfigurationManager.AppSettings["SourcePath"] + "metrics/" + resultFileName + "_" + resultfileType + "_" + offset / count + "_Metric.txt", FileMode.OpenOrCreate, FileAccess.Write);

            var outFile = new StreamWriter(outFileStream);
            var timer   = new Stopwatch();

            for (var i = offset; i < offset + count; i++)
            {
                var response = ExcelApi.ExcelConvertToPDFWithHttpInfo(Path.GetFileNameWithoutExtension(sourceFileName) + /*"_" + i +*/ Path.GetExtension(sourceFileName) + sourceFileType, Path.GetFileNameWithoutExtension(resultFileName) + "_" + i + Path.GetExtension(resultFileName) + resultfileType);
                if (response.StatusCode >= 200 && response.StatusCode <= 205)
                {
                    //var pdfResponse = WordApi.WordConvertToPDFWithHttpInfo(sourceFileName + "_" + i + "." + sourceFileType, resultFileName + "_" + i + "." + resultfileType);
                    if (response.Data != null && response.StatusCode >= 200 && response.StatusCode <= 205)
                    {
                        var data = response.Data.Replace("\"", "");
                        outFile.WriteLine(data + "\n\n");
                        Console.WriteLine(sourceFileName + "_" + i + "." + sourceFileType + " view success!");
                    }
                    else
                    {
                        outFile.WriteLine(sourceFileName + "_" + i + "." + sourceFileType + " view failed!");
                        Console.WriteLine(sourceFileName + "_" + i + "." + sourceFileType + " view failed!");
                    }
                }
                else
                {
                    Console.WriteLine("File view failed!");
                }
            }

            Console.WriteLine("\n\nAll " + sourceFileType + " files converted successfully!");
            outFile.Close();
        }
Example #9
0
 void WorkCompleted(object sender, RunWorkerCompletedEventArgs e)
 {
     ExcelApi.Dispose();
     bgWorker.Dispose();
     this.Close();
 }
Example #10
0
 /// <summary>
 /// Creates an instance of the application
 /// </summary>
 /// <param name="application">owner application</param>
 public CommonUtils(ExcelApi.Application application) : base(application)
 {
     _ownerApplication = application;
 }
Example #11
0
        static void Main(string[] args)
        {
            string   outMessage;
            Employee emp = new Employee
            {
                Email_ID    = "eeee",
                Employee_ID = "42323232",
                Name        = "Eli Arad",
                Number      = "e11999"
            };

            Employee emp1 = new Employee
            {
                Email_ID    = "Eli",
                Employee_ID = "027104918",
                Name        = "El9999",
                Number      = "050480277"
            };

            List <Employee> employees = new List <Employee>();

            employees.Add(emp);
            employees.Add(emp1);
            ExcelApi.CloseExcel();
            ExcelApi t = new ExcelApi();

            string fileName = "c:\\MyExcelFile.xlsx";

            if (t.NewFile(fileName) == true)
            {
                Console.WriteLine("File Created");
                t.UpdateSheetName(0, "Eli Arad 1", out outMessage);


                if (t.WriteStruct <Employee>(1, 10, 2, employees, out outMessage) == false)
                {
                }

                /*
                 * for (int i = 1; i < 5; i++)
                 * {
                 *  if (t.AddWorkSheetAtTheEnd("Eli Arad " + (i + 1), out outMessage) == false)
                 *  {
                 *
                 *  }
                 * }
                 */
                //t.UpdateSheetName(0, "7777", out outMessage);
            }
            else
            {
                t.OpenFile(fileName);

                /*
                 * if (t.AddWorkSheetAtTheEnd("gggggggg", out outMessage) == false)
                 * {
                 *
                 * }
                 *
                 * if (t.UpdateLastSheetName("121212", out outMessage) == false)
                 * {
                 *
                 * }
                 */

                List <object> myvalues;
                t.ReadRowList(1,
                              1,
                              1,
                              out myvalues,
                              5,
                              out outMessage);

                if (t.WriteCell(1, 1, 1, "Hello world", out outMessage) == false)
                {
                    Console.WriteLine("error: " + outMessage);
                }
                if (t.WriteCell(1, 1, 1, "Hello world", out outMessage) == false)
                {
                    Console.WriteLine("error: " + outMessage);
                }

                if (t.WriteCell(2, 1, 1, "Hello world", true, Color.Red, Color.Transparent, out outMessage) == false)
                {
                    Console.WriteLine("error: " + outMessage);
                }


                if (t.WriteStruct <Employee>(1, 5, 2, emp, out outMessage) == false)
                {
                }
                Employee remp = new Employee();
                t.ReadStruct <Employee>(1, 6, 2, ref remp, out outMessage);


                if (t.WriteStruct <Employee>(1, 10, 2, employees, out outMessage) == false)
                {
                }

                List <Employee> remp1 = new List <Employee>();
                t.ReadStruct <Employee>(1, 11, 2, ref remp1, 2, out outMessage);

                List <object> data1 = new List <object>();

                data1.Add("Eli");
                data1.Add("1");
                data1.Add("0.2323");
                data1.Add("Arad");
                data1.Add("12112");
                t.WriteLine(1, 20, 1, data1, out outMessage);
            }
            t.Close(true);
        }
Example #12
0
        private void worker_DoWork(object sender, DoWorkEventArgs e)
        {
            IObjectSpace objectSpace = Application.CreateObjectSpace();

            BusinessObjects.Appraisaldb.options option = SqlOp.GetOptionalue(objectSpace, Types.OptionsType.FilesPath.ToString());

            ObservableCollection <UpdateFile> fileslst = new ObservableCollection <UpdateFile>();

            ShowDialog(fileslst);
            string[] files = Directory.GetFiles(option.option_value, "*.xlsx", SearchOption.AllDirectories);
            ProgressMax   = files.Length;
            ProgressValue = 0;

            foreach (string file in files)
            {
                fileslst.Add(new UpdateFile(file));
            }


            foreach (UpdateFile file in fileslst)
            {
                ProgressValue = ProgressValue + 1;
                try
                {
                    //1 Personal, 3 Behaviours, 4 Objectives, 5 Development, 6 ObjectivesNy
                    //0 Personal, 1 Behaviours, 2 Objectives, 3 Development, 4 ObjectivesNy
                    List <DataTable> sheets = ExcelApi.LoadExcelFile_VBA(file.FilePath, new[] { 1, 3, 4, 5, 7 });

                    //Personal
                    int personnelId;// = Convert.ToInt32(sheets[0].Rows[12][2]);
                    if (!int.TryParse(sheets[0].Rows[12][2].ToString(), out personnelId))
                    {
                        personnelId = (DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Second +
                                       DateTime.Now.Millisecond) * -1;
                    }
                    personnel_master personnel = objectSpace.GetObjectByKey <personnel_master>(personnelId);
                    if (personnel == null)
                    {
                        personnel = objectSpace.CreateObject <personnel_master>();
                        personnel.personnel_id = personnelId;
                    }
                    personnel.personnel_name       = sheets[0].Rows[11][2].ToString();
                    personnel.job_name             = sheets[0].Rows[13][2].ToString();
                    personnel.time_in_current_role = sheets[0].Rows[16][5].ToString();
                    if (DateTime.TryParse(sheets[0].Rows[14][5].ToString(), out DateTime reviewDate))
                    {
                        personnel.review_date = reviewDate;
                    }
                    personnel.job_description = sheets[0].Rows[17][5].ToString();
                    if (int.TryParse(sheets[0].Rows[12][7].ToString(), out int managerId))
                    {
                        personnel.manager_id = managerId;
                    }
                    personnel.manager_name     = sheets[0].Rows[11][7].ToString();
                    personnel.last_update_date = DateTime.Now;
                    personnel.file_path        = file.FilePath;

                    //Delete before insert
                    objectSpace.Delete(personnel.objectives);
                    objectSpace.Delete(personnel.objective_next_years);
                    objectSpace.Delete(personnel.developments);

                    //Behaviours
                    GetBehaviours(personnel, sheets);
                    //Objectives
                    GetObjectives(sheets, personnel, objectSpace);
                    //Development
                    GetDevelopment(sheets[3], personnel, objectSpace);
                    //ObjectivesNy
                    GetObjectivesNy(sheets[4], personnel, objectSpace);

                    objectSpace.CommitChanges();
                    file.OpResult = Types.OperationResult.Success;
                    Refresh();
                }
                catch (Exception exception)
                {
                    Console.WriteLine(exception);
                    file.OpResult  = Types.OperationResult.Fail;
                    file.ResultMsg = exception.Message;
                }
            }
        }