From a6f65537fd87ae065fe5cec62863ac4380d2a745 Mon Sep 17 00:00:00 2001
From: lu <123456>
Date: 星期四, 28 八月 2025 11:15:54 +0800
Subject: [PATCH] 销售退货单增加字段
---
DevApp/Gs.DevApp/UserControl/CopyXls.cs | 18 +++++++++++++++++-
1 files changed, 17 insertions(+), 1 deletions(-)
diff --git a/DevApp/Gs.DevApp/UserControl/CopyXls.cs b/DevApp/Gs.DevApp/UserControl/CopyXls.cs
index 0317ead..2824a33 100644
--- a/DevApp/Gs.DevApp/UserControl/CopyXls.cs
+++ b/DevApp/Gs.DevApp/UserControl/CopyXls.cs
@@ -1,4 +1,5 @@
-锘縰sing DevExpress.Spreadsheet;
+锘縰sing CefSharp.DevTools.Debugger;
+using DevExpress.Spreadsheet;
using DevExpress.XtraEditors;
using System;
using System.Collections.Generic;
@@ -33,6 +34,7 @@
{
IWorkbook workbook = spreadsheetControl1.Document;
workbook.LoadDocument(filePath);
+ // SetCellText(spreadsheetControl1.ActiveWorksheet, location, item.F_Name, true);
}
else
{
@@ -66,5 +68,19 @@
{
spreadsheetControl1.SaveDocument();
}
+
+ /// <summary>
+ /// 浠庢暟鎹簱閲岃鍙栧埌Excel
+ /// </summary>
+ /// <param name="workSheet"></param>
+ /// <param name="coordinates">浣嶇疆鏍煎紡濡侫1 B2</param>
+ /// <param name="coordValue">鍊�</param>
+ /// <param name="isBold">鏄惁鍔犵矖</param>
+ private void SetCellText(Worksheet workSheet, string coordinates, string coordValue, bool isBold)
+ {
+ workSheet.Cells[coordinates].Value = coordValue;
+ workSheet.Cells[coordinates].Style.Font.Bold = isBold;
+ }
+
}
}
\ No newline at end of file
--
Gitblit v1.9.3