使用excel生成批量pdf [英] generating bulk pdf using excel
问题描述
大家好,
任何人都可以帮我用c#生成一个宏。我希望在选择2列后生成该宏并生成具有特定格式的pdf文件,如下所示:
FILE 1
美国XYZ学校
名称ValueOfColumn1& Row1
年龄ValueOfColumn2& Row1 < br $>
FILE 2
美国XYZ学校
名称ValueOfColumn1& Row2
Age ValueOfColumn2& Row2
请帮帮我!
谢谢,>
Akkywadhwa
宏使用c#? C#不是一种宏语言 - 您可以使用Excel VBA或C#来完成工作...从Excel 2007及更高版本中,您可以导出为PDF而无需任何外部组件,但您需要将文件作为工作簿的一页看起来像你的愿望。比你可以改变工作表的内容并逐一生成pdf'。以下是如何使用VBA导出为PDF的示例: http: //excelvbaandmacros.blogspot.hu/2012/01/excel-create-pdf-from-excel-worksheet.html [ ^ ],相关官方支持: http://msdn.microsoft.com/en-us/library/office/ee834871(v = office.11)的.aspx [ ^ ]。
Hi guys,
Can anyone help me to generate a macro using c#. I want that macro to be enabled after selecting 2 columns and generate pdf files with a particular format as follows:
FILE 1
XYZ School,USA
Name ValueOfColumn1&Row1
Age ValueOfColumn2&Row1
FILE 2
XYZ School,USA
Name ValueOfColumn1&Row2
Age ValueOfColumn2&Row2
Please help me out!
Thanks,
Akkywadhwa
Macro using c#? C# is not a macro language - you either do your job using Excel VBA or C#... From Excel 2007 and above you can export to PDF without any external component, but you need to make your "file" as a sheet of the workbook to look as you desire. Than you can change the worksheet''s content and generate the pdf''s one by one. Here is a sample of how to use VBA to export to PDF: http://excelvbaandmacros.blogspot.hu/2012/01/excel-create-pdf-from-excel-worksheet.html[^], related official support: http://msdn.microsoft.com/en-us/library/office/ee834871(v=office.11).aspx[^].
这篇关于使用excel生成批量pdf的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!