- 博客(12)
- 资源 (18)
- 问答 (2)
- 收藏
- 关注
原创 c# 设置颜色
lbl.ForeColor=ColorTranslator.FromHtml("#CCC0DA");微信截图在百度搜 40 44 52
2020-09-30 11:15:16 704
原创 c# vsto 隐藏分组列
/// <summary> /// 表格范围隐藏并分组 /// </summary> /// <param name="range">传如[A1:G1]的Range</param> static public void SetRangeHiddenAndGroup(Range range) { range.Columns.Hidden = true; ..
2020-09-28 19:31:35 257
原创 c# 数值分段,如如参数:12,5,返回[1-5,6-10,11-12]
/// <summary> /// 数值分段 /// </summary> /// <param name="num">数值</param> /// <param name="size">尺寸</param> /// <param name="size">如参数:25,10,返回[1-10,11-20,21-25]</pa...
2020-09-28 16:38:04 335
原创 winform c# 隐藏关闭按钮
private const int CP_NOCLOSE_BUTTON = 0x200;protected override CreateParams CreateParams{ get { CreateParams myCp = base.CreateParams; myCp.ClassStyle = myCp.ClassStyle | CP_NOCLOSE_BUTTON ; return myCp; }}
2020-09-28 15:49:35 877
原创 c# winform 指定位置打开窗体
ClsWinWrap clsWinWrap = new ClsWinWrap(Globals.ThisAddIn.Application.Hwnd); var should = new Should(CurWorkbook); int xWidth = SystemInformation.PrimaryMonitorSize.Width; int yHeight = SystemInformation.P.
2020-09-27 20:13:34 494
原创 vsto c# 操作excel数据量大出现黑屏
Application app=newApplication(); bool oldScreenUpdatingSetting = app.ScreenUpdating;var sheet = (Worksheet)workbook.Sheets[subject]; try { app.ScreenUpdating = false; var Range=sheet.get_R...
2020-09-25 17:36:52 203
原创 anaconda 对应的缓存文件转移到空间大的磁盘
1、cmd 输入 conda info2、修改文件【C:\Users\您的用户名\.condarc】3、把【.conda】目录移到大空间的磁盘
2020-09-18 17:03:01 2456 4
原创 c# excel 获取打开的excel文件名称
Target.Application.ActiveWorkbook.Name;//文件全路径Target.Application.ActiveWorkbook.FullName;
2020-09-04 15:42:13 753
原创 c# vsto excel 设置某个sheet选中
var currentSheetName = Globals.ThisAddIn.Application.ActiveWorkbook.ActiveSheet.Name.ToString();//切换到加载全部时选中的sheet Globals.ThisAddIn.Application.ActiveWorkbook.Sheets[currentSheetName].Activate();
2020-09-02 17:21:42 676
原创 c# excel vsto 获取sheet最大的使用范围
var sheetRange = Worksheet.UsedRange.Address.Replace("$", "");
2020-09-01 17:27:03 378
office-vsto开发.pdf
2021-11-24
Office安装时候彻底清除历史文件工具之有效版
2020-12-16
ExcelAddIn3.zip
2020-12-11
Weiz.Lab-dgv-表头全选.zip
2020-11-19
ASP.NET MVC Application Using Entity Framework Code First
2014-04-14
c# 获取下面的最子级 双斜杠的都是获取的值
2021-11-08
app绑定微信成功 app怎么知道绑定成功了
2016-11-29
TA创建的收藏夹 TA关注的收藏夹
TA关注的人