带工作表的Excel工作表路径 [英] excel sheet path with worksheet

查看:106
本文介绍了带工作表的Excel工作表路径的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述



-i将.xls转换为.pdf文件我成功完成了这个但我的问题是



假设我有一个名为 xyz.xls 的excel文件,在该excel文件中有3个(三个)工作表 A,B和C ,我想创建仅 B的pdf 工作表如何传递参数 paramSourceBookPath



excelWorkBook = excelApplication.Workbooks.Open( paramSourceBookPath ,paramMissing,paramMissing,paramMissing,paramMissing,paramMissing,paramMissing,paramMissing,paramMissing,paramMissing,paramMissing,paramMissing,paramMissing,paramMissing,paramMissing);









currenty i pass @C:\xyz .xls但是它将所有树A,B,C作为一个Pdf中的组合但是我不想要A和C我只需要 B 工作表作为pdf。





-i按照以下链接执行此操作。



http://msdn.microsoft.com/en-us/library/bb407651%28v=office.12%29 .aspx [ ^ ]


-i convert .xls to .pdf file i done this successfully but my problem is that

suppose i have a one excel file with name xyz.xls and in that excel file 3(three) worksheet A,B and C and i want to create pdf of only B worksheet how i pass parameter "paramSourceBookPath"

excelWorkBook = excelApplication.Workbooks.Open(paramSourceBookPath, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing);




currenty i pass @"C:\xyz.xls" but it crtae all tree A, B,C as a combine in one Pdf But i dont want A and C i need Only B worksheet as a pdf.


-i follow below link for do this.

http://msdn.microsoft.com/en-us/library/bb407651%28v=office.12%29.aspx[^]

推荐答案

在那里你会找到你的解决方案:将Excel(.xls)文件转换为.pdf文件 [ ^ ]。

仔细阅读我的评论;)并尝试!
There you'll find your solution: Convert Excel(.xls) file to .pdf File[^].
Read my comments carefully ;) and try!


这篇关于带工作表的Excel工作表路径的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆