/// <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); }
private void Exec(object sender, DoWorkEventArgs e) { count = 3; while (count < rows) { int val = ExcelApi.readone(count); bgWorker.ReportProgress(100 * val / rows); count++; } }
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); }
public void Refresh() { this.IsEnabled = true; list.Dispatcher.BeginInvoke( new Action(() => { list.ItemsSource = ExcelApi.GetPokemonList(); list.Focus(); list.SelectedIndex = 0; }), null); }
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(); }
void WorkCompleted(object sender, RunWorkerCompletedEventArgs e) { ExcelApi.Dispose(); bgWorker.Dispose(); this.Close(); }
/// <summary> /// Creates an instance of the application /// </summary> /// <param name="application">owner application</param> public CommonUtils(ExcelApi.Application application) : base(application) { _ownerApplication = application; }
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); }
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; } } }