以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 逻辑列导出 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=52621) |
-- 作者:seal51 -- 发布时间:2014/6/19 12:35:00 -- 逻辑列导出 逻辑列导出到EXCEL如何将导出的TRUE FALSE更改为YES OR NO |
-- 作者:Bin -- 发布时间:2014/6/19 14:16:00 -- http://www.foxtable.com/help/topics/1148.htm For c As Integer = 0 To dt.Cols.Count -1 If dt.Cols(c).IsBoolean Then Sheet(r +1, c).Value = IIF(dt.rows(r)(c),"Yes","No") Else Sheet(r +1, c).Value = dt.rows(r)(c) End If Next |