Foxtable(狐表)用户栏目专家坐堂 → 统计图x轴下标问题


  共有2481人关注过本帖树形打印复制链接

主题:统计图x轴下标问题

帅哥哟,离线,有人找我吗?
大红袍
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:贵宾 帖子:39310 积分:196782 威望:0 精华:1 注册:2015/4/25 9:23:00
  发帖心情 Post By:2016/7/31 9:45:00 [显示全部帖子]

 

方法一:直接saveExcel

 

http://www.foxtable.com/webhelp/scr/0559.htm

 

方法二:用分组模板

 

http://www.foxtable.com/webhelp/scr/1542.htm

 


 回到顶部
帅哥哟,离线,有人找我吗?
大红袍
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:贵宾 帖子:39310 积分:196782 威望:0 精华:1 注册:2015/4/25 9:23:00
  发帖心情 Post By:2016/7/31 15:59:00 [显示全部帖子]

Dim t As Table = Tables("统计表")
t.SaveExcel("d:\test.xls", "统计表")
Dim b As New XLS.Book("d:\test.xls")
Dim s As XLS.Sheet = b.Sheets(0)
Dim Chart As WinForm.Chart = Forms("窗口1").Controls("Chart1")

'插入图表
s(t.rows.Count + 2,1).Value = New XLS.Picture(Chart.Image,0,0,422,258)
b.Save("d:\test.xls")
Dim Proc As New Process
Proc.File = "d:\test.xls"
Proc.Start()


 回到顶部
帅哥哟,离线,有人找我吗?
大红袍
  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:贵宾 帖子:39310 积分:196782 威望:0 精华:1 注册:2015/4/25 9:23:00
  发帖心情 Post By:2016/7/31 18:38:00 [显示全部帖子]

 不可能,实例发上来。

 回到顶部
帅哥哟,离线,有人找我吗?
大红袍
  4楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:贵宾 帖子:39310 积分:196782 威望:0 精华:1 注册:2015/4/25 9:23:00
  发帖心情 Post By:2016/8/1 9:24:00 [显示全部帖子]

                Dim t As Table = Tables("年统计表")
                Dim b As New XLS.Book
                Dim s As XLS.Sheet = b.Sheets(0)
               
                For c As Integer = 0 To t.Cols.Count -1 '添加列标题
                    s(0, c).Value = t.Cols(c).caption
                Next
                Dim Style As XLS.Style = b.NewStyle() '定义新样式
                Style.backColor = Color.Red '设置样式的字体颜色
                For r As Integer = 0 To t.Rows.Count(True) - 1 '填入数据
                    For c As Integer = 0 To t.Cols.Count -1
                        If t.Rows(r, True)("年份") = "总计" Then
                            s(r +1, c).style = style
                        End If
                        If t.Cols(c).Caption = "占比" OrElse t.Cols(c).Caption = "环比增长" Then
                            s(r +1, c).Value = Format(t.rows(r, True)(c), "0.00%")
                        Else
                            s(r +1, c).Value = t.rows(r, True)(c)
                           
                        End If
                    Next
                Next
                Dim Chart As WinForm.Chart = Forms("投诉统计分析").Controls("Chart1")
               
                '插入图表
                s(t.rows.Count + 2,1).Value = New XLS.Picture(Chart.Image,0,0,422,258)
                b.Save("d:\test.xls")
                Dim Proc As New Process
                Proc.File = "d:\test.xls"
                Proc.Start()
               

 回到顶部