Hi, I am using Excel to Word conversion, If my excel sheet contains large number of rows , then how re-size word document page size according to rows columns in word document. Thanks in advance
Thanks for your inquiry. Unfortunately, there is no direct way to convert Word document to Excel. However, it is possible using Aspose.Words and Aspose.Cells. I have attached a simple converter for you (See the attached class). Here is how you should use it:
Document doc = new Document("C:\\Temp\\sample.doc"); ConverterDoc2Xls converter = new ConverterDoc2Xls(); Workbook wb = converter.Convert(doc); wb.Save("C:\\Temp\\out.xls");
Please use PageHeight and PageWidth properties of PageSetup class to set height/width of the page in points. Hope this helps you.
If you still face problem, please manually create your expected Word document using Microsoft Word and attach it here along with input Excel file for our reference. We will investigate as to how you want your final Word output be generated like. We will then provide you more information on this along with code.