private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
if (e.Error != null)
{
MessageBox.Show(e.Error.Message, " Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (e.Cancelled)
{
// cnnOLEDBx.Close();
MessageBox.Show("Task Cancelled by User!", " Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
Excel1.DisplayAlerts = false;
TotalError = sitenotexist;
if (TotalError > 0)
{
Worksheet1.Activate();
Excel.Range myRange;
myRange = Worksheet1.Range["A2", "Z" + Worksheet1.UsedRange.Rows.Count.ToString()];
myRange.Select();
myRange.Sort(Key1: myRange.Range["A2"], Order1: Microsoft.Office.Interop.Excel.XlSortOrder.xlAscending, Orientation: Microsoft.Office.Interop.Excel.XlSortOrientation.xlSortColumns);
if (File.Exists(Path.GetDirectoryName(openFileDialog1.FileName).ToString() + @"\" + Path.GetFileNameWithoutExtension(openFileDialog1.SafeFileName).ToString() + " - Site Not Registered" + Path.GetExtension(openFileDialog1.FileName)))
{
File.Delete(Path.GetDirectoryName(openFileDialog1.FileName).ToString() + @"\" + Path.GetFileNameWithoutExtension(openFileDialog1.SafeFileName).ToString() + " - Site Not Registered" + Path.GetExtension(openFileDialog1.FileName));
Worksheet1.SaveAs(Path.GetDirectoryName(openFileDialog1.FileName).ToString() + @"\" + Path.GetFileNameWithoutExtension(openFileDialog1.SafeFileName).ToString() + " - Site Not Registered" + Path.GetExtension(openFileDialog1.FileName));
}
else
{
Worksheet1.SaveAs(Path.GetDirectoryName(openFileDialog1.FileName).ToString() + @"\" + Path.GetFileNameWithoutExtension(openFileDialog1.SafeFileName).ToString() + " - Site Not Registered" + Path.GetExtension(openFileDialog1.FileName));
}
MessageBox.Show("Cannot upload file.. \n\n" + "View error log saved in " + Path.GetDirectoryName(openFileDialog1.FileName).ToString() + ".", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
getMaxLineItems2();
Execute2();
}
}
Workbook1.Close();
Excel1.Quit();
releaseObject(Excel1);
releaseObject(Workbook1);
releaseObject(Worksheet1);
}
public void exportexcelGA1(ref DataGridViewCommon dgv, string link, string filename, string model, string line, string dateFrom, string dateTo)
{
try
{
Excel.Application excelApp = new Excel.Application();
excelApp.Workbooks.Add();
Excel.Worksheet ws = excelApp.ActiveSheet;
ws.Cells[1, 1] = "Model:"; ws.Cells[1, 2] = model;
ws.Cells[1, 3] = "Line:"; ws.Cells[1, 4] = line;
ws.Cells[2, 1] = "From;"; ws.Cells[2, 2] = dateFrom;
ws.Cells[2, 3] = "To:"; ws.Cells[2, 4] = dateTo;
// column headings
for (int i = 0; i < dgv.Columns.Count; i++)
{
ws.Cells[4, (i + 1)] = dgv.Columns[i].HeaderText;
}
// rows
for (int j = 0; j < dgv.Columns.Count; j++)
{
for (int i = 0; i < dgv.Rows.Count; i++)
{
ws.Cells[(i + 5), (j + 1)] = dgv[j, i].Value.ToString();
if (i < dgv.RowCount - 1)
{
if (dgv.Rows[i].Cells["process"].Value.ToString() == dgv.Rows[i + 1].Cells["process"].Value.ToString())
{
ws.Range[ws.Cells[i + 5, 1], ws.Cells[i + 6, 1]].Merge();
}
}
}
}
excelApp.Visible = true;
if (link.Length == 3)
{
ws.SaveAs(link + filename + ".xlsx");
}
else
{
ws.SaveAs(link + @"\" + filename + ".xlsx");
}
}
catch
{
MessageBox.Show("ERROR. Please create folder " + link + " to save as...");
return;
}
}
private void button3_Click(object sender, EventArgs e)
{
string path = "";
Microsoft.Office.Interop.Excel.Application exApp = new Microsoft.Office.Interop.Excel.Application();
exApp.Workbooks.Add();
Microsoft.Office.Interop.Excel.Worksheet workSheet = (Microsoft.Office.Interop.Excel.Worksheet)exApp.ActiveSheet;
for (int i = 0; i < dataGridView1.ColumnCount; i++)
{
workSheet.Cells[1, i + 1] = dataGridView1.Columns[i].HeaderText;
}
DateTime datevalue;
for (int i = 0; i < dataGridView1.RowCount - 1; i++)
{
for (int j = 0; j < dataGridView1.ColumnCount; j++)
{
if (DateTime.TryParse(dataGridView1.Rows[i].Cells[j].Value.ToString(), out datevalue) == false)
{
workSheet.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value;
}
else
{
workSheet.Cells[i + 2, j + 1] = Convert.ToDateTime(dataGridView1.Rows[i].Cells[j].Value).ToLongDateString();
}
}
}
workSheet.Cells.ColumnWidth = 30;
path = Environment.CurrentDirectory + "\\Excel.xlsx";
workSheet.SaveAs(path);
exApp.Quit();
MessageBox.Show("Файл был сохранен в текущей рабочей папке!", "Успех!", MessageBoxButtons.OK);
}
protected void CreateExcelFile(string FileName, string sheetName, string[] colName)
{
//create
object Nothing = System.Reflection.Missing.Value;
var app = new Excel.Application();
app.Visible = false;
Excel.Workbook workBook = app.Workbooks.Add(Nothing);
Excel.Worksheet worksheet = (Excel.Worksheet)workBook.Sheets[1];
worksheet.Name = sheetName;
for (int i = 0; i < colName.Count(); i++)
{
worksheet.Cells[1, i + 1] = colName[i];
}
////headline
//worksheet.Cells[1, 1] = "日志ID";
//worksheet.Cells[1, 2] = "内容";
//worksheet.Cells[1, 3] = "类别";
//worksheet.Cells[1,4] = "日志来源";
//worksheet.Cells[1, 5] = "时间";
worksheet.SaveAs(FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing);
workBook.Close(false, Type.Missing, Type.Missing);
app.Quit();
}
public void exportexcel(ref DataGridViewCommon dgv, string link, string filename)
{
try
{
Excel.Application excelApp = new Excel.Application();
excelApp.Workbooks.Add();
Excel.Worksheet ws = excelApp.ActiveSheet;
// column headings
for (int i = 0; i < dgv.Columns.Count; i++)
{
ws.Cells[1, (i + 1)] = dgv.Columns[i].HeaderText;
}
// rows
for (int i = 0; i < dgv.Rows.Count; i++)
{
for (int j = 0; j < dgv.Columns.Count; j++)
{
if (dgv[j, i].Value != null)
{
ws.Cells[(i + 2), (j + 1)] = dgv[j, i].Value.ToString();
}
}
}
excelApp.Visible = true;
ws.SaveAs(link + @"\" + filename + ".xlsx");
}
catch
{
MessageBox.Show("ERROR. Please create folder " + link + " to save as...");
return;
}
}
public static void ExcelCOM(string[,] data, string savePath)
{
Excel.Application excelApp = new Excel.Application(); // Excel App 생성
Excel.Workbook workbook = excelApp.Workbooks.Add(Type.Missing); //sheet1 포함된 빈 워크북 생성
Excel.Worksheet worksheetA = workbook.Worksheets.Item["Sheet1"]; //sheet1 객체 가져오기
Excel.Worksheet worksheetB = workbook.Worksheets.Add(After: worksheetA); //sheet1 뒤에 새 워크시트 추가
Excel.Range range = null;
for (int i = 0; i < data.GetLength(0); i++)
{
worksheetA.Cells[i + 1, 1] = data[i, 0]; // Cells[열, 행], data[2차, 1차]
worksheetA.Cells[i + 1, 2] = data[i, 1];
}
range = worksheetB.Cells[1, 1]; //sheet2 | A1
range.Formula = "Sheet2"; //sheet1 뒤 시트 | A1 기록
range = worksheetB.Cells[2, 1]; //sheet2 | A2
range.Formula = "Sheet2"; //sheet1 뒤 시트 | A1 기록
worksheetA.SaveAs(savePath + "\\shpark-book.xlsx"); // sheep1 저장
excelApp.Quit(); //Excel App 종료
}
private void BtnToExcel_Click(object sender, RoutedEventArgs e)
{
Excel.Application excel = new Excel.Application();
excel.Visible = true;
excel.Workbooks.Add();
Excel.Worksheet worksheet = (Excel.Worksheet)excel.ActiveSheet;
worksheet.Cells[1, 1] = "№";
worksheet.Cells[1, 2] = "Товар";
worksheet.Cells[1, 3] = "Количиство";
worksheet.Cells[1, 4] = "Цена";
worksheet.Cells[1, 5] = "Сумма";
int row = 2;
for (int i = 0; i < orders.Count; i++, row++)
{
worksheet.Cells[row, 1] = orders[i].ID;
worksheet.Cells[row, 2] = orders[i].Product;
worksheet.Cells[row, 3] = orders[i].Quantity;
worksheet.Cells[row, 4] = orders[i].Price;
worksheet.Cells[row, 5] = orders[i].Sum;
}
row++;
Excel.Range range = worksheet.get_Range(string.Format("D" + row), string.Format("E" + row)).Cells;
range.Merge(Type.Missing);
worksheet.Cells[row, 4] = "Итого: " + total;
worksheet.Columns.AutoFit();
worksheet.SaveAs(@"C:\Users\Koss4ok\Desktop\MyExcel");
excel.Quit();
}
//
//// Supprimer typologie dans "D:\\ptw\\Histo.ptw"
//
private void renommer()
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
object misValue = System.Reflection.Missing.Value;
//missing values, for example, when you invoke methods that have default parameter values.
//remplace les paramètres par default des fonctions utilisés
xlApp = new Excel.ApplicationClass();
xlApp.Visible = true;
xlWorkBook = xlApp.Workbooks.Open(fichierprepare, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, true, false);
//Afficher pas les Alerts !!non utiliser avant assurer!!!
xlApp.DisplayAlerts = false;
Excel.Worksheet xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item("Historique");
//Excel.Worksheet sheetTypologie = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item("Typologie IFRS");
//sheetTypologie.Delete();
xlWorkSheet.SaveAs(prefaceNP, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet); //kill WorkSheet
releaseObject(xlWorkBook); //Kill WorkBook
releaseObject(xlApp); //Kill Application Application
}
private void 保存ToolStripMenuItem_Click(object sender, EventArgs e)
{
saveFileDialog1.Title = "附和水准计算保存";
saveFileDialog1.Filter = "文本文件(*.txt)|*.txt|Excel数据文件(*.xls)|*.xls|Excel表格(*.xlsx)|*.xlsx";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
#region TXT文档保存
if (saveFileDialog1.FilterIndex == 1)
{
StreamWriter sw = new StreamWriter(saveFileDialog1.FileName);
sw.WriteLine("附合水准平差计算\n");
Class1.daochu1(sw, dataGridView4);
sw.WriteLine("高程配赋平差计算\n");
Class1.daochu1(sw, dataGridView3);
sw.Flush();
MessageBox.Show("保存成功！");
}
#endregion
#region Excel文档保存
else
{
Excel.Application excel1 = new Excel.Application(); //创建一个excel对象
Excel.Workbook workbook1 = excel1.Workbooks.Add(true); //为该excel对象添加一个工作簿
Excel.Worksheet worksheet1 = excel1.Workbooks[1].Worksheets[1]; //获取工作簿中的第一个工作表
Class1.daochu2(1, worksheet1, dataGridView4);
Class1.daochu2(dataGridView2.Rows.Count + 2, worksheet1, dataGridView3);
worksheet1.SaveAs(saveFileDialog1.FileName);//保存工作表
workbook1.Close();
MessageBox.Show("保存成功！");
}
#endregion
}
}
private void ExportToExcel()
{
Excel.Application exApp = new Excel.Application();
//exApp.Visible = true;
exApp.Workbooks.Open(Environment.CurrentDirectory + @"\Шаблон.xls");
Excel.Worksheet workSheet = (Excel.Worksheet)exApp.ActiveSheet;
workSheet.Cells[1, 1] = "Cпеціальність " + comboBox1.Text;
workSheet.Cells[2, 1] = "#";
workSheet.Cells[2, 2] = "ПІБ";
workSheet.Cells[2, 3] = "Дата народження";
workSheet.Cells[2, 4] = "Пільги";
workSheet.Cells[2, 5] = "Номер телефону";
workSheet.Cells[2, 6] = "Рейтигновий бал вступу";
workSheet.Cells[2, 7] = "Тип вступу";
int rowExcel = 3;
int y = 1, counter = 1;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
workSheet.Cells[rowExcel, "A"] = counter.ToString();
workSheet.Cells[rowExcel, "B"] = dataGridView1.Rows[i].Cells["ПІБ"].Value;
workSheet.Cells[rowExcel, "C"] = dataGridView1.Rows[i].Cells["Дата_народження"].Value;
workSheet.Cells[rowExcel, "D"] = dataGridView1.Rows[i].Cells["Пільги"].Value;
workSheet.Cells[rowExcel, "E"] = dataGridView1.Rows[i].Cells["Номер_телефону"].Value;
workSheet.Cells[rowExcel, "F"] = dataGridView1.Rows[i].Cells["Рейтигновий_бал_вступу"].Value;
workSheet.Cells[rowExcel, "G"] = dataGridView1.Rows[i].Cells["Тип_вступу"].Value;
++rowExcel;
++counter;
}
workSheet.SaveAs("Вступники на спеціальність " + comboBox1.Text + ".xls");
exApp.Quit();
MessageBox.Show("Файл був збережений в папці 'Мої документи' під назвою 'Вступники на спеціальність " + comboBox1.Text + ".xls'", "Інформація", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 在制定的文件夹创建Excel文件
/// </summary>
static ExcelInterop()
{
app = new Excel.Application();
app.Visible = false;
Excel.Worksheet worksheet = null;
string fileName = Constants.CurrentDirectory + '\\' + DateTime.Now.ToString("yyyyMMdd_hhmmss") + ".xlsx";
if (System.IO.File.Exists(fileName))
{
workBook = app.Workbooks.Open(fileName);
worksheet = (Excel.Worksheet)workBook.Sheets[1];
itemIdx = worksheet.UsedRange.Rows.Count + 1;
return;
}
object Nothing = System.Reflection.Missing.Value;
string childName = "Data Info";
workBook = app.Workbooks.Add(Nothing);
worksheet = (Excel.Worksheet)workBook.Sheets[1];
worksheet.Name = childName;
itemIdx = 2;
string[] headItems = { "时间", "ID编号", "ID号", "X坐标", "Y坐标" };
int idx = 1;
foreach (string strItem in headItems)
{
worksheet.Cells[1, idx++] = strItem;
}
worksheet.SaveAs(fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing);
}
//---> 'mergeRecords_Click'
/* Activates the main and final segment of this program. Will only run if valid workforce and master
* record files have been loaded and passed all checks. There are two main parts to this function:
* 1) a call to the 'copyRecords' function, passing in the current master and workforce Excel
* worksheets and the row number where records for the current year begin (description of function
* is at function declaration)
* 2) a call to the 'parseNumbers' function, passing just the current master record file
* (description of function is at function declaration) */
private void mergeRecords_Click(object sender, EventArgs e)
{
//pointers for shorter names
Excel.Worksheet currentMaster = masterSheets.get_Item(this.masterTabName());
Excel.Worksheet currentWorkforce = workforceSheets.get_Item(DateTime.Now.Year.ToString());
//this.copyRecords(currentMaster, currentWorkforce, this.masterStartPoint(currentMaster));
//this.parseNumbers(currentMaster);
currentMaster.SaveAs("C:\\Users\\Jumbo\\Desktop\\Master " + DateTime.Now.Millisecond + ".xlsx",
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing);
//update location and progress tracker
this.programLocation.Text = "Done";
this.progress.Text = String.Empty;
//kill final processes
this.killWorkforce();
this.killMaster();
}
private void buttonSave_Click(object sender, EventArgs e)
{
string fileName = Application.StartupPath + "\\" + "op13" + ".xlsx",
fileName_new = Application.StartupPath + "\\" + "time_op13_new" + ".xlsx";
Excel.Application exApp = new Excel.Application();
//Получаем набор ссылок на объекты Workbook
Excel.Workbook excelappworkbooks = exApp.Workbooks.Open(fileName,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
// Получить первый рабочий лист.
Excel.Worksheet excelsheets = (Excel.Worksheet)excelappworkbooks.Sheets[1];
//заполняем строку
excelsheets.Cells[49, "P"] = comboBoxMade.Text;
excelsheets.Cells[49, "AH"] = textBoxMade.Text;
excelsheets.Cells[13, "AR"] = comboBoxApproved.Text;
excelsheets.Cells[15, "AS"] = textBoxApproved.Text;
excelsheets.Cells[51, "P"] = textBoxAccountant.Text;
//Save to file
excelsheets.SaveAs(fileName_new);
exApp.Quit();
this.Close();
}
public static void ExportToExcel <T>(List <T> data)
{
// Create Excell application
Exc.Application excApp = new Exc.Application();
// Create empty excel workbook
excApp.Workbooks.Add();
// Identify worksheet
Exc.Worksheet worksheet = excApp.ActiveSheet;
// Identify column headings
worksheet.Cells[1, "A"] = "COLOR";
worksheet.Cells[1, "B"] = "BRAND";
// Insert Car List data into excel cells
int row = 2;
foreach (var item in data as List <Car> )
{
worksheet.Cells[row, "A"] = item.Color;
worksheet.Cells[row, "B"] = item.Brand;
row++;
}
worksheet.SaveAs($@"{Environment.CurrentDirectory}\Garage.xlsx");
excApp.Quit();
Console.WriteLine($"The garage list has been saved under this directory: {Environment.CurrentDirectory }");
}
static void Main(string[] args)
{
Excel.Application xlApp = null;
Excel.Workbook xlWorkBook = null;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Add();
Excel.Worksheet newWorksheet = null;
newWorksheet = (Excel.Worksheet)xlApp.Application.Worksheets.Add();
xlApp.ScreenUpdating = false;
Excel.Range excelRange = newWorksheet.UsedRange;
// Column 1
excelRange.Cells.set_Item(1, 1, "Column 1");
// Column 1 Data
excelRange.Cells.set_Item(2, 1, "sss");
// Column 2
excelRange.Cells.set_Item(1, 2, "Column 2");
// Column 1 Data
excelRange.Cells.set_Item(2, 2, "ttt");
// Save it as .xls
newWorksheet.SaveAs("D:\\ExcelInterop", Excel.XlFileFormat.xlExcel7);
// Clean up
xlWorkBook.Close();
xlApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlWorkBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);
}
private void Accept_Click(object sender, EventArgs e)
{
try
{
Microsoft.Office.Interop.Excel.Range range = ObjWorkSheet1.get_Range("E:E").Find(PCName2.Text);
ObjWorkSheet1.get_Range("D" + range.Row.ToString()).Value2 = SerialNum2.Text;
ObjWorkSheet1.get_Range("C" + range.Row.ToString()).Value2 = PCModel2.Text;
ObjWorkSheet1.get_Range("L" + range.Row.ToString()).Value2 = IPN2.Text;
ObjWorkSheet1.get_Range("O" + range.Row.ToString()).Value2 = BuildingBox.Text;
ObjWorkSheet1.get_Range("P" + range.Row.ToString()).Value = Room.Text;
ObjWorkSheet1.get_Range("K" + range.Row.ToString()).Value = StatusBox.Text;
ObjWorkSheet1.SaveAs(file);
clear();
MessageBox.Show("Файл успешно сохранен!", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
PCName2.Text = "";
PCModel2.Text = "";
SerialNum2.Text = "";
BuildingBox.Text = "";
IPN2.Text = "";
Room.Text = "";
StatusBox.Text = "";
clear();
Accept.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex + "\n" + "Невозможно сохранить файл");
}
}
public void DrawFunction()
{
List <USModel> mylist = new List <USModel>();
mylist = Reader.ReadToEndTheCases(dataset_path, "Gwinnett").Difference();
List <int> data = new List <int>(mylist.Count);
int[] date = new int[mylist.Count];
for (int i = 0; i < mylist.Count; i++)
{
data.Add(mylist[i].Cases);
date[i] = i + 1;
}
data.ToArray();
excel = new Microsoft.Office.Interop.Excel.Application();
excel.Visible = false;
excel.DisplayAlerts = false;
worKbooK = excel.Workbooks.Add(Type.Missing);
worKsheeT = (Microsoft.Office.Interop.Excel.Worksheet)worKbooK.ActiveSheet;
worKsheeT.Name = "DataForDraw";
for (var i = 0; i < data.Count; i++)
{
worKsheeT.Cells[i + 1, 1] = data[i];
worKsheeT.Cells[i + 1, 2] = date[i];
}
worKsheeT.SaveAs(excel_path);
excel.Quit();
Console.WriteLine(excel.Name);
}
static void Oldway(string[,] data, string savePath)//COM(Component Object Model - 마이크로소프트 사의 소프트웨어 컴포넌트 규격)을 이용하여 엑셀에 접근하기
{
Excel.Application excelApp = new Excel.Application();
excelApp.Workbooks.Add(Type.Missing);
Excel.Worksheet worksheet = (Excel.Worksheet)excelApp.ActiveSheet;
for (int i = 0; i < data.GetLength(0); i++)
{
((Excel.Range)worksheet.Cells[i + 1, 1]).Value2 = data[i, 0];
((Excel.Range)worksheet.Cells[i + 1, 2]).Value2 = data[i, 1];
}
worksheet.SaveAs(savePath + "\\shjang-book-old.xlsx",
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing
);
excelApp.Quit();
}
/// <summary>
/// Toma una plantilla de Excel y una serie de cambios a
/// realizar sobre dicho documento y genera un archivo nuevo
/// con las modificionesespecificadas.
/// </summary>
/// <param name="rutaFinal">Ruta donde se almacenará el archivo
/// generado</param>
/// <param name="rutaPlantilla">Ruta donde se encuentra la plantilla
/// a usar</param>
/// <param name="listaDatos">Lista de cambios a realizar sobre las
/// celdas de la plantilla</param>
/// <returns>Retorna un booleano que indica si la creación se realizó
/// con éxito.</returns>
public static bool LlenarPlantillaConDatos(String rutaFinal, String rutaPlantilla, List <DatoCelda> listaDatos)
{
// Iniciar Excel
Excel.Application excel = new Excel.Application();
try
{
// Cargar la plantilla de Excel
Excel.Workbook book = excel.Workbooks.Open(rutaPlantilla);
Excel.Worksheet sheet = excel.ActiveSheet as Excel.Worksheet;
// Carga de datos al archivo
foreach (DatoCelda dc in listaDatos)
{
sheet.Cells[dc.Fila, dc.Columna] = dc.Valor;
}
sheet.SaveAs(rutaFinal);
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
finally
{
excel.Quit();
}
}
private void CreateExcelFile(string FileName)
{
//create
object Nothing = System.Reflection.Missing.Value;
Excel.Application app = null;
app = new Excel.Application();
app.Visible = false;
Excel.Workbook workBook = app.Workbooks.Add(Nothing);
Excel.Worksheet worksheet = (Excel.Worksheet)workBook.Sheets[1];
Excel.Range range = (Excel.Range)worksheet.get_Range("A1", "E1");
range.Font.Size = 15;
range.Font.Name = "黑体";
worksheet.Name = "record";
range.ColumnWidth = 25;
range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
range.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
//headline
worksheet.Cells[1, 1] = "设备名称";
worksheet.Cells[1, 2] = "发生时间";
worksheet.Cells[1, 3] = "设备序列号";
worksheet.Cells[1, 4] = "操作类型";
worksheet.Cells[1, 5] = "操作人";
worksheet.SaveAs(FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing);
workBook.Close(false, Type.Missing, Type.Missing);
app.Quit();
}
private void btnExport_Click(object sender, EventArgs e)
{
excel.Application app = new excel.Application();
excel.Worksheet ws = app.Workbooks.Add(Type.Missing).Sheets[1];
ws.Cells[1, 1].Value = "Date";
ws.Cells[1, 2].Value = "Team(Away)";
ws.Cells[1, 3].Value = "Team(Home)";
ws.Cells[1, 4].Value = "Time";
ws.Cells[1, 5].Value = "Location";
ws.Cells[1, 6].Value = "Finished";
ws.Range["A1:F1"].Font.Bold = true;
for (int i = 2; i < dgvRegularSeason.Rows.Count; i++)
{
ws.Cells[i, 1].Value = Convert.ToString(dgvRegularSeason.Rows[i - 2].Cells[0].Value);
ws.Cells[i, 2].Value = Convert.ToString(dgvRegularSeason.Rows[i - 2].Cells[1].Value);
ws.Cells[i, 3].Value = Convert.ToString(dgvRegularSeason.Rows[i - 2].Cells[2].Value);
ws.Cells[i, 4].Value = Convert.ToString(dgvRegularSeason.Rows[i - 2].Cells[3].Value);
ws.Cells[i, 5].Value = Convert.ToString(dgvRegularSeason.Rows[i - 2].Cells[4].Value);
ws.Cells[i, 6].Value = Convert.ToString(dgvRegularSeason.Rows[i - 2].Cells[5].Value);
}
ws.Columns.AutoFit();
ws.SaveAs(AppDomain.CurrentDomain.BaseDirectory + @"export.xlsx");
app.Quit();
Marshal.ReleaseComObject(ws);
Marshal.ReleaseComObject(app);
MessageBox.Show("Your file is export on the path " + AppDomain.CurrentDomain.BaseDirectory + @"export.xlsx");
}
public static void OldWay(string[,] data, string savePath)
{
Excel.Application excelApp = new Excel.Application();
excelApp.Workbooks.Add(Type.Missing);
Excel.Worksheet workSheet = (Excel.Worksheet)excelApp.ActiveSheet;
for (int i = 0; i < data.GetLength(0); i++)
{
((Excel.Range)workSheet.Cells[i + 1, 1]).Value2 = data[i, 0];
((Excel.Range)workSheet.Cells[i + 1, 2]).Value2 = data[i, 1];
}
workSheet.SaveAs(savePath + "\\shpark-book-old.xlsx",
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing);
excelApp.Quit();
}
public string ExportPositions(IEnumerable <PositionsController.PositionExportViewModel> data, string filename)
{
var path = Path.Combine(HttpContext.Current.Server.MapPath(uploadDirPosition)) + "\\" + filename + ".xlsx";
if (File.Exists(path))
{
File.Delete(path);
}
Excel.Application xlAppToExport = new Excel.Application();
xlAppToExport.Workbooks.Add("");
// ADD A WORKSHEET.
Excel.Worksheet xlWorkSheetToExport = default(Excel.Worksheet);
xlWorkSheetToExport = (Excel.Worksheet)xlAppToExport.Sheets["Sheet1"];
// ROW ID FROM WHERE THE DATA STARTS SHOWING.
int iRowCnt = 8;
// SHOW THE HEADER.
xlWorkSheetToExport.Cells[1, 1] = "Position Details";
Excel.Range range = xlWorkSheetToExport.Cells[1, 1] as Excel.Range;
range.EntireRow.Font.Name = "Calibri";
range.EntireRow.Font.Bold = true;
range.EntireRow.Font.Size = 20;
xlWorkSheetToExport.Range["A1:D1"].MergeCells = true; // MERGE CELLS OF THE HEADER.
// SHOW COLUMNS ON THE TOP.
xlWorkSheetToExport.Cells[iRowCnt - 1, 1] = "Name";
xlWorkSheetToExport.Cells[iRowCnt - 1, 2] = "Description";
xlWorkSheetToExport.Cells[iRowCnt - 1, 3] = "Level of experience";
xlWorkSheetToExport.Cells[iRowCnt - 1, 4] = "Technology";
xlWorkSheetToExport.Cells[iRowCnt - 1, 5] = "Employees assigned";
int i;
for (i = 0; i <= data.Count() - 1; i++)
{
xlWorkSheetToExport.Cells[iRowCnt, 1] = data.ElementAt(i).Name;
xlWorkSheetToExport.Cells[iRowCnt, 2] = data.ElementAt(i).Description;
xlWorkSheetToExport.Cells[iRowCnt, 3] = data.ElementAt(i).LevelOfExperience;
xlWorkSheetToExport.Cells[iRowCnt, 4] = data.ElementAt(i).Technology;
xlWorkSheetToExport.Cells[iRowCnt, 5] = data.ElementAt(i).Employees;
iRowCnt = iRowCnt + 1;
}
// SAVE THE FILE IN A FOLDER.
xlWorkSheetToExport.SaveAs(path);
// CLEAR.
xlAppToExport.Workbooks.Close();
xlAppToExport.Quit();
xlAppToExport = null;
return(path);
}
public void saveExcel()
{
try
{
string desktopPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
string path1 = System.IO.Path.Combine(desktopPath, "강의자료.xlsx");
excelApp = new Excel.Application();
excelApp.DisplayAlerts = false;
workBook = excelApp.Workbooks.Add();
workSheet = workBook.Worksheets.get_Item(1) as Excel.Worksheet;
workSheet.Cells[1, 1] = "강의명";
workSheet.Cells[1, 2] = "제 목";
workSheet.Cells[1, 3] = "작성일";
for (int i = 0; i < VM.getCount1(); i++)
{
workSheet.Cells[2 + i, 1] = VM.getList1().ElementAt(i).LmsSubject;
workSheet.Cells[2 + i, 2] = VM.getList1().ElementAt(i).LmsTitle;
workSheet.Cells[2 + i, 3] = VM.getList1().ElementAt(i).LmsRdate;
}
workSheet.Columns.AutoFit();
workSheet.SaveAs(path1, Excel.XlFileFormat.xlWorkbookDefault);
workBook.Close(true);
excelApp.Quit();
}
finally
{
ReleaseObject(workSheet);
ReleaseObject(workBook);
ReleaseObject(excelApp);
}
}
public static void CreateExcelFile(string fileName, string sheetName, string[] title, int[] content)
{
//删除原来数据
string filePath = "/Statis/" + fileName + ".xlsx";
if (File.Exists(filePath))
{
File.Delete(filePath);
}
object Nothing = System.Reflection.Missing.Value;
OfficeExcel.Application excel = new OfficeExcel.Application();
OfficeExcel.Workbook workBook = excel.Workbooks.Add(Nothing);
OfficeExcel.Worksheet worksheet = (OfficeExcel.Worksheet)workBook.Sheets.Add();
worksheet.Name = sheetName;
int idx = 1;
foreach (string item in title)
{
worksheet.Cells[1, idx++] = item;
}
idx = 1;
foreach (int item in content)
{
worksheet.Cells[2, idx++] = item;
}
worksheet.SaveAs(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, OfficeExcel.XlSaveAsAccessMode.xlNoChange);
workBook.Save();
workBook.Close(true);
excel.Quit();
}
internal void CreateExcelFile(string FileName)
{
//create
object Nothing = System.Reflection.Missing.Value;
var app = new Excel.Application();
app.Visible = false;
Excel.Workbook workBook = app.Workbooks.Add(Nothing);
Excel.Worksheet worksheet = (Excel.Worksheet)workBook.Sheets[1];
worksheet.Name = FileName;
//headline
worksheet.Cells[1, 1] = "名称";
worksheet.Cells[1, 2] = "编码";
//worksheet.Cells[1, 2].numberFormatting = "@";
worksheet.Cells[1, 3] = "简码";
worksheet.Cells[1, 4] = "商品分类编码";
worksheet.Cells[1, 5] = "税率";
//worksheet.Cells[1, 5].numberFormatting = "formatnumber";
worksheet.Cells[1, 6] = "规格/厂牌";
worksheet.Cells[1, 7] = "计量单位";
worksheet.Cells[1, 8] = "适用税率";
worksheet.Cells[1, 9] = "含税标志";
worksheet.Cells[1, 10] = "优惠政策类型";
worksheet.Cells[1, 11] = "免税类型";
worksheet.Columns[2].NumberFormatLocal = "@";//设置第二列为 文本格式
worksheet.Columns[4].NumberFormatLocal = "@";
worksheet.SaveAs(FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing);
workBook.Close(false, Type.Missing, Type.Missing);
app.Quit();
}
private void ConvertAndSaveFile(Excel.Worksheet workSheet)
{
String directory = Path.GetDirectoryName(this.sourceFullPath);
directory += "\\" + Path.GetFileNameWithoutExtension(this.sourceFullPath);
directory += "\\";
DirectoryInfo directoryInfo = new DirectoryInfo(directory);
if (!directoryInfo.Exists)
{
directoryInfo.Create();
}
this.destFullPath = directory + workSheet.Name + this.destExtention;
if (checkDeleteColumnValue == workSheet.Range[checkDeleteColumnCell].Value2.ToString())
{
workSheet.Columns[deleteColumn].Delete();
}
((Excel.Range)workSheet.Rows[deleteRow, Type.Missing]).Delete(Excel.XlDeleteShiftDirection.xlShiftUp);
workSheet.SaveAs(this.destFullPath, Excel.XlFileFormat.xlCSV);
}
private void initializeWorkSheetGameModeEasy()
{
// Het verbinden van de path die nodig om de locatie te vinden van de Excel worksheet (highscores.xlsx).
string RunningPath = AppDomain.CurrentDomain.BaseDirectory;
string path = string.Format("{0}Resources\\highscores", System.IO.Path.GetFullPath(System.IO.Path.Combine(RunningPath, @"..\..\")));
if (!File.Exists(path + "\\highscoresGMEasy.xls"))
{
xlApp = new Microsoft.Office.Interop.Excel.Application();
object misValue = System.Reflection.Missing.Value;
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = xlWorkBook.Worksheets.get_Item(1);
xlWorkSheet.Cells[1, 1] = "ID";
xlWorkSheet.Cells[1, 2] = "Name";
xlWorkSheet.Cells[1, 3] = "Score";
xlWorkSheet.SaveAs(path + "\\highscoresGMEasy.xls");
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
Marshal.ReleaseComObject(xlWorkSheet);
Marshal.ReleaseComObject(xlWorkBook);
Marshal.ReleaseComObject(xlApp);
}
}
public void ExportDataSetToExcel(DataSet ds, string fileName)
{
//Creae an Excel application instance
Excel.Application excelApp = new Excel.Application();
//Create an Excel workbook instance and open it from the predefined location
Excel.Workbook excelWorkBook = excelApp.Workbooks.Add();
foreach (DataTable table in ds.Tables)
{
//Add a new worksheet to workbook with the Datatable name
Excel.Worksheet excelWorkSheet = excelWorkBook.Sheets.Add();
excelWorkSheet.Name = table.TableName;
for (int i = 1; i < table.Columns.Count + 1; i++)
{
excelWorkSheet.Cells[1, i] = table.Columns[i - 1].ColumnName;
}
for (int j = 0; j < table.Rows.Count; j++)
{
for (int k = 0; k < table.Columns.Count; k++)
{
excelWorkSheet.Cells[j + 2, k + 1] = table.Rows[j].ItemArray[k].ToString();
}
}
excelWorkSheet.SaveAs(table.TableName);
}
excelWorkBook.SaveAs(fileName);
excelWorkBook.Close();
excelApp.Quit();
}
public void WriteTable(DataTable dt, string filename)
{
if (!StartExcel())
{
return;
}
// Fill headers
for (int colIndex = 0; colIndex < dt.Columns.Count; ++colIndex)
{
xlWorksheet.Cells[1, (colIndex + 1)] = dt.Columns[colIndex].ColumnName;
}
// Write data
for (int rowIndex = 0; rowIndex < dt.Rows.Count; ++rowIndex)
{
for (int colIndex = 0; colIndex < dt.Columns.Count; ++colIndex)
{
xlWorksheet.Cells[(rowIndex + 2), (colIndex + 1)] = dt.Rows[rowIndex][colIndex];
}
}
xlWorksheet.SaveAs(filename);
StopExcel();
}
private void btnExport_Click(object sender, RoutedEventArgs e)
{
exportProgress.Minimum = 0;
exportProgress.Maximum = TestInfoList.Count ;
exportProgress.Value = 0;
double value = 0;
UpdateProgressBarDelegate updatePbDelegate = new UpdateProgressBarDelegate(exportProgress.SetValue);
try
{
excelApp = new ApplicationClass();
Workbooks myWorkBooks = excelApp.Workbooks;
myWorkBooks.Open(templatePath, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
Sheets sheets = excelApp.Sheets;
mySheet1 = (Worksheet)sheets[1];
mySheet1.Activate();
int rowCount = TestInfoList.Count + 2; ;//总行数
//写入参数信息
int paramCount = 0;//参数行数
if (IsExportParams)
{
paramCount = ParamList.Count * 4;
for (int i = 0; i < ParamList.Count; i++)
{
Model.Parameter p = ParamList[i];
Range r = mySheet1.get_Range(mySheet1.Cells[1, testInfoColumnCount + i * 4 + 1], mySheet1.Cells[1, testInfoColumnCount + i * 4 + 4]);
r.Merge();
r.Value = p.ParamName;
r.Font.Bold = true;
r.HorizontalAlignment = XlHAlign.xlHAlignCenter;
r.VerticalAlignment = XlHAlign.xlHAlignCenter;
Range r1 = mySheet1.get_Range(mySheet1.Cells[2, testInfoColumnCount + i * 4 + 1], mySheet1.Cells[2, testInfoColumnCount + i * 4 + 4]);
r1.Value2 = paramContents;
r1.Font.Bold = true;
r1.EntireColumn.AutoFit();
}
}
//写入测试信息
string[,] content = new string[rowCount, testInfoColumnCount + paramCount];
//double?[,] paramContent = new double?[rowCount, paramCount];
XDocument xdoc;
BLL.TB_Dict dictBLL = new BLL.TB_Dict();
for (int i = 0; i < TestInfoList.Count; i++)
{
int rowIndex = i;
Model.TestInfoModel model = TestInfoList[i];
content[rowIndex, 0] = string.Format("测试{0}", i + 1);//测试顺序
content[rowIndex, 1] = model.Ath_Name;//姓名
content[rowIndex, 2] = model.TestDate.ToString("yyyy-MM-dd HH:mm");//测试日期
content[rowIndex, 3] = model.DJoint;//测试关节
content[rowIndex, 4] = model.DJointSide;//测试侧
content[rowIndex, 5] = model.DPlane;//运动方式
content[rowIndex, 6] = model.DTestMode;//测试模式
content[rowIndex, 7] = model.MotionRange;//运动范围
content[rowIndex, 8] = model.Speed;//测试速度
content[rowIndex, 9] = model.Break;//休息时间
content[rowIndex, 10] = model.NOOfSets;//测试组数
content[rowIndex, 11] = model.NOOfRepetitions;//重复次数
content[rowIndex, 12] = model.DInsuredSide;//受伤测
content[rowIndex, 13] = model.DGravitycomp;//重力补偿
if (IsExportParams)
{
string xmlPath = Model.AppPath.XmlDataDirPath + model.DataFileName;
xdoc = XDocument.Load(xmlPath);
List<XElement> action1 = xdoc.Descendants("action1").Elements<XElement>().ToList<XElement>();
List<XElement> action2 = xdoc.Descendants("action2").Elements<XElement>().ToList<XElement>();
for (int j = 0; j < ParamList.Count; j++)
{
int paramOneColumnIndex = j * 4;
double p1;
if (double.TryParse(action1[ParamList[j].Index].Attribute("max").Value, out p1)) {
//paramContent[rowIndex, paramOneColumnIndex] = p1;
mySheet1.Cells[rowIndex + 3, paramOneColumnIndex + testInfoColumnCount + 1] = p1;
}
double p2;
if (double.TryParse(action1[ParamList[j].Index].Attribute("avg").Value, out p2))
{
//paramContent[rowIndex, paramOneColumnIndex + 1] = p2;
mySheet1.Cells[rowIndex + 3, paramOneColumnIndex + testInfoColumnCount + 2] = p2;
}
double p3;
if (double.TryParse(action2[ParamList[j].Index].Attribute("max").Value, out p3))
{
//paramContent[rowIndex, paramOneColumnIndex + 2] = p3;
mySheet1.Cells[rowIndex + 3, paramOneColumnIndex + testInfoColumnCount + 3] = p3;
}
double p4;
if (double.TryParse(action2[ParamList[j].Index].Attribute("avg").Value, out p4))
{
//paramContent[rowIndex, paramOneColumnIndex + 3] = p4;
mySheet1.Cells[rowIndex + 3, paramOneColumnIndex + testInfoColumnCount + 4] = p4;
}
}
}
//写进度条
value += 1;
Dispatcher.Invoke(updatePbDelegate,
System.Windows.Threading.DispatcherPriority.Background,
new object[] { ProgressBar.ValueProperty, value });
}
//写入测试信息
Range range1 = mySheet1.get_Range(mySheet1.Cells[3, 1], mySheet1.Cells[rowCount, testInfoColumnCount]);
range1.Value2 = content;
//写入参数信息
//Range range2 = mySheet1.get_Range(mySheet1.Cells[3, testInfoColumnCount + 1], mySheet1.Cells[rowCount, testInfoColumnCount + paramCount]);
//range2.Value2 = paramContent;
//if (IsExportParams)
//{
// rowCount = TestInfoList.Count + (ParamList.Count + 1) * TestInfoList.Count + 1;//信息行数+信息行数×参数行数+第一行列头信息
// paramCount = ParamList.Count + 1;//参数行数加1行参数名
//}
//else {
// rowCount = TestInfoList.Count + 1;
//}
//string[,] content = new string[rowCount, 13];
//XDocument xdoc;
//Model.TB_Dict actionModel;
//BLL.TB_Dict dictBLL = new BLL.TB_Dict();
//for (int i = 0; i < TestInfoList.Count; i++) {
// int rowIndex = i + i * paramCount;
// Model.TestInfoModel model = TestInfoList[i];
// content[rowIndex, 0] = model.Ath_Name;//姓名
// content[rowIndex, 1] = model.TestDate.ToString("yyyy-MM-dd HH:mm");//测试日期
// content[rowIndex, 2] = model.DJoint;//测试关节
// content[rowIndex, 3] = model.DJointSide;//测试侧
// content[rowIndex, 4] = model.DPlane;//运动方式
// content[rowIndex, 5] = model.DTestMode;//测试模式
// content[rowIndex, 6] = model.MotionRange;//运动范围
// content[rowIndex, 7] = model.Speed;//测试速度
// content[rowIndex, 8] = model.Break;//休息时间
// content[rowIndex, 9] = model.NOOfSets;//测试组数
// content[rowIndex, 10] = model.NOOfRepetitions;//重复次数
// content[rowIndex, 11] = model.DInsuredSide;//受伤测
// content[rowIndex, 12] = model.DGravitycomp;//重力补偿
// if (IsExportParams) {
// //写入参数信息
// actionModel = dictBLL.GetModel(model.Joint, model.Plane, model.Test_Mode);
// content[rowIndex + 1, 0] = "所选测试顺序";
// content[rowIndex + 1, 1] = "参数";
// content[rowIndex + 1, 2] = actionModel.actionone + "(极值)";
// content[rowIndex + 1, 3] = actionModel.actionone + "(平均值)";
// content[rowIndex + 1, 4] = actionModel.actiontwo + "(极值)";
// content[rowIndex + 1, 5] = actionModel.actiontwo + "(平均值)";
// string xmlPath = Model.AppPath.XmlDataDirPath + model.DataFileName;
// xdoc = XDocument.Load(xmlPath);
// List<XElement> action1 = xdoc.Descendants("action1").Elements<XElement>().ToList<XElement>();
// List<XElement> action2 = xdoc.Descendants("action2").Elements<XElement>().ToList<XElement>();
// for (int j = 0; j < ParamList.Count; j++)
// {
// content[rowIndex + 1 + j + 1, 0] = "测试" + (i + 1);
// content[rowIndex + 1 + j + 1, 1] = ParamList[j].ParamName;
// content[rowIndex + 1 + j + 1, 2] = action1[ParamList[j].Index].Attribute("max").Value;
// content[rowIndex + 1 + j + 1, 3] = action1[ParamList[j].Index].Attribute("avg").Value;
// content[rowIndex + 1 + j + 1, 4] = action2[ParamList[j].Index].Attribute("max").Value;
// content[rowIndex + 1 + j + 1, 5] = action2[ParamList[j].Index].Attribute("avg").Value;
// }
// }
// //写进度条
// value += 1;
// Dispatcher.Invoke(updatePbDelegate,
// System.Windows.Threading.DispatcherPriority.Background,
// new object[] { ProgressBar.ValueProperty, value });
//}
//Range range = mySheet1.get_Range(mySheet1.Cells[2, 1], mySheet1.Cells[rowCount, 13]);
//range.Value2 = content;
mySheet1.SaveAs(choosePath, missing, missing, missing, missing, missing, missing, missing, missing, missing);
myWorkBooks.Close();
excelApp.Quit();
MessageBox.Show("导出成功！", "系统信息");
System.Windows.Window.GetWindow(this).Close();
}
catch (Exception ee) {
MessageBox.Show("导出出错！\r\n错误信息为：" + ee.Message, "系统错误");
}
}
public void Export(List<List<XElement>> datalist,string savePath)
{
try
{
excelApp = new ApplicationClass();
Workbooks myWorkBooks = excelApp.Workbooks;
myWorkBooks.Open(templatePath, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
Sheets sheets = excelApp.Sheets;
mySheet1 = (Worksheet)sheets[1];
mySheet1.Activate();
int rowCount = 1 + 2; ;//总行数
//写入参数信息
int paramCount = 0;//参数行数
List<DSJL.Model.Parameter> paramList = DSJL.Model.Parameter.GetAllParams();
paramCount = paramList.Count * 4;
for (int i = 0; i < paramList.Count; i++)
{
Model.Parameter p = paramList[i];
Range r = mySheet1.get_Range(mySheet1.Cells[1, testInfoColumnCount + i * 4 + 1], mySheet1.Cells[1, testInfoColumnCount + i * 4 + 4]);
r.Merge();
r.Value = p.ParamName;
r.Font.Bold = true;
r.HorizontalAlignment = XlHAlign.xlHAlignCenter;
r.VerticalAlignment = XlHAlign.xlHAlignCenter;
Range r1 = mySheet1.get_Range(mySheet1.Cells[2, testInfoColumnCount + i * 4 + 1], mySheet1.Cells[2, testInfoColumnCount + i * 4 + 4]);
r1.Value2 = paramContents;
r1.Font.Bold = true;
r1.EntireColumn.AutoFit();
}
//写入测试信息
string[,] content = new string[rowCount, testInfoColumnCount + paramCount];
//double?[,] paramContent = new double?[rowCount, paramCount];
BLL.TB_Dict dictBLL = new BLL.TB_Dict();
int rowIndex = 0;
//content[rowIndex, 0] ="";//测试顺序
//content[rowIndex, 1] = model.Ath_Name;//姓名
//content[rowIndex, 2] = model.TestDate.ToString("yyyy-MM-dd HH:mm");//测试日期
//content[rowIndex, 3] = model.DJoint;//测试关节
//content[rowIndex, 4] = model.DJointSide;//测试侧
//content[rowIndex, 5] = model.DPlane;//运动方式
//content[rowIndex, 6] = model.DTestMode;//测试模式
//content[rowIndex, 7] = model.MotionRange;//运动范围
//content[rowIndex, 8] = model.Speed;//测试速度
//content[rowIndex, 9] = model.Break;//休息时间
//content[rowIndex, 10] = model.NOOfSets;//测试组数
//content[rowIndex, 11] = model.NOOfRepetitions;//重复次数
//content[rowIndex, 12] = model.DInsuredSide;//受伤测
//content[rowIndex, 13] = model.DGravitycomp;//重力补偿
List<XElement> action1 = datalist[0];
List<XElement> action2 = datalist[1];
for (int j = 0; j < paramList.Count; j++)
{
int paramOneColumnIndex = j * 4;
double p1;
if (double.TryParse(action1[paramList[j].Index].Attribute("max").Value, out p1))
{
//paramContent[rowIndex, paramOneColumnIndex] = p1;
mySheet1.Cells[rowIndex + 3, paramOneColumnIndex + testInfoColumnCount + 1] = p1;
}
double p2;
if (double.TryParse(action1[paramList[j].Index].Attribute("avg").Value, out p2))
{
//paramContent[rowIndex, paramOneColumnIndex + 1] = p2;
mySheet1.Cells[rowIndex + 3, paramOneColumnIndex + testInfoColumnCount + 2] = p2;
}
double p3;
if (double.TryParse(action2[paramList[j].Index].Attribute("max").Value, out p3))
{
//paramContent[rowIndex, paramOneColumnIndex + 2] = p3;
mySheet1.Cells[rowIndex + 3, paramOneColumnIndex + testInfoColumnCount + 3] = p3;
}
double p4;
if (double.TryParse(action2[paramList[j].Index].Attribute("avg").Value, out p4))
{
//paramContent[rowIndex, paramOneColumnIndex + 3] = p4;
mySheet1.Cells[rowIndex + 3, paramOneColumnIndex + testInfoColumnCount + 4] = p4;
}
}
//写入测试信息
Range range1 = mySheet1.get_Range(mySheet1.Cells[3, 1], mySheet1.Cells[rowCount, testInfoColumnCount]);
range1.Value2 = content;
mySheet1.SaveAs(savePath, missing, missing, missing, missing, missing, missing, missing, missing, missing);
myWorkBooks.Close();
excelApp.Quit();
}
catch (Exception ee)
{
throw ee;
}
finally {
DSJL.Model.Parameter.CheckDefault();
}
}
