用NODEJS处理EXCEL文件导入导出

佚名2017-09-22编程 2872°  0
t) { // write var data = [[1,2,3],[true, false, null, 'sheetjs'],['foo','bar',new Date('2014-02-19T14:30Z'), '0.3'], ['baz', null, 'qux']]; var buffer = xlsx.build([{name: "mySheetName", data: data}]); fs.writeFileSync('b.xls

c#无弹窗调用打印机

佚名2017-09-22编程 3029°  0
float topMargin = 0; String line = null; linesPerPage = ev.MarginBounds.Height / printFont.GetHeight(ev.Graphics); while (count < linesPerPage && ((line = streamToPrint.ReadLine()) != null)) { if (count =

C#操作QQ邮箱发送电子邮件

佚名2019-10-30编程 2127°  0
tedMethod) { if (mailMessage != null) { smtpClient = new SmtpClient(); smtpClient.EnableSsl = true;// 指定 System.Net.Mail.SmtpClient 是否使用安全套接字层 (SSL) 加密连接,必须在实例身份前面设置 smtpClient.UseDefaultCredentials = false; s

C#替换特殊字符防SQL注入

佚名2019-11-07编程 2349°  0
tring ReplaceSQLChar(string str){ if (string.IsNullOrEmpty(str)) return ""; str = str.Replace("'", ""); str = str.Replace(";", ""); str = str.Replace(",", ""); str = str.Replace("?", ""); str = str.Replace("<", ""); str = str.Replace(">", ""); str = str.Replace("(",

网易企业邮箱退信代码说明

佚名2019-11-15办公 1982°  0
小超过了网易邮箱允许接收的最大限制;553 Requested action not taken: NULL sender is not allowed 不允许发件人为空,请使用真实发件人发送;553 Requested action not taken: Local user only SMTP类型的机器只允许发信人是本站用户;553 Requested action not taken: no smtp MX only MX类型的机器不允许发信人是本站用户;553 authentication is required SMTP需要身份验证,请检查客户端设置;554 DT:SPM 发

Visual Studio(VS) F12 查看DLL源代码

佚名2019-11-15软件 2477°  0
n=0.7.6285.31046, Culture=neutral, PublicKeyToken=null// MVID: E539F3DE-C53C-4567-99E9-7697E4765856// Assembly location: D:\Git\xxx\TableML\TableML.dllVS2017已经内置,F12直接到反编译的源码工具>选项>文本编辑器>c#>高级>启用支持导航到反编译源。

sqlite isnull函数

佚名2019-11-22数据库 2942°  0
在SQLite中没有isnull函数,想要使用isnull函数,可以使用ifnull函数,跟isnull用法一样。demo:select ifnull(catid,0) from category

C#控制定位Word光标位置

佚名2019-12-02编程 2315°  0
alue);}private void moveRight(){ if(selection==null||selection!=document.Application.Selection) selection=document.Application.Selection; object dummy=System.Reflection.Missing.Value; object count=1; object Unit=Word.WdUnits.wdCharacter; selection.MoveRight(ref Unit,ref count,

sql with as递归的实现(树形结构)

佚名2019-12-17数据库 1939°  0
o].[Company]( [id] [NVARCHAR](50) NOT NULL, --Id 主键 [companyName] [NVARCHAR](50) NULL, --公司名称 [pId] [NVARCHAR](50) NULL --父节点id) ON [PRIMARY];二、 插入数据到公司表INSERT INTO Company (id, companyName, pid) VALUES ('A', 'A总公司', '/'); --总公司INSERT INTO Company (id, companyName, pid) VA

C#视频播放器

佚名2019-12-18编程 2068°  0
ypath; } }}【注意】:要先定义变量string playpath = null;string directory = null;List<string> playArray = null;和线性表public List<string> GetplayCollection(string path){ string[] playarray = Directory.GetFiles(path); var result = from playstring in playarray where playstring.EndsWi