/// <summary> /// 脚本执行完成, 将生成的csv文件合并成XLS文件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void CurrentWorker_RunComplete(object sender, EventArgs e) { if (FileType != InOut.FileType.XLS) { return; } Workbook workbook = new Workbook(); foreach (string variable in filePaths.Keys) { Worksheet worksheet = new Worksheet(variable); using (var csv = new CsvReader(new StreamReader(filePaths[variable], Encoding.UTF8))) { csv.Configuration.Delimiter = ","; csv.Configuration.HasHeaderRecord = false; int rowindex = 0; while (csv.Read()) { string[] records = csv.CurrentRecord; for (int i = 0; i < records.Length; i++) { worksheet.Cells[rowindex, i] = new Cell(records[i]); } rowindex++; } } workbook.Worksheets.Add(worksheet); } FileStream stream = null; try { string path = Path.Combine(AppSettings.Instance.CurrentExecutePath, "data"); string file = VariableModel.Parse(FileName); string outputFile = Path.Combine(path, file.IndexOf(".") == -1 ? (file + ".xls") : (file.Substring(0, file.IndexOf(".")) + ".xls")); stream = new FileStream(outputFile, FileMode.Create); workbook.SaveToStream(stream); } finally { foreach (string file in filePaths.Values) { try { File.Delete(file); } catch { } } Reset(); if (stream != null) { stream.Close(); } } }
public virtual void GoToURL() { string bindVal = Eval(BindName); if (!string.IsNullOrEmpty(bindVal)) { URL = bindVal; } string url = VariableModel.Parse(URL); Goto(url); }
public override void Perform() { string _fileName = VariableModel.Parse(FileName); AutoRobo.Core.IO.DataTableReader reader = new AutoRobo.Core.IO.DataTableReader(FileType, _fileName, HasHeaderRecord); var varObj = ActionModel.VariableActionModel.Find <ActionTableVariable>(VariableName); try { varObj.Data = reader.Read(); } catch (Exception ex) { LogWrite(string.Format("读文件{0}失败", _fileName)); LogWrite(ex.Message); } }
private void InitializeFilePath() { if (filePaths.Count > 0) { return; } string _fileName = VariableModel.Parse(FileName); string path = Path.Combine(AppSettings.Instance.CurrentExecutePath, "data"); _fileName = Path.Combine(path, GetFileName(_fileName)); string[] vars = VariableName.Split(",".ToCharArray()); foreach (string v in vars) { filePaths.Add(v, _fileName.Insert(_fileName.IndexOf("."), "_" + v)); } }