Transfer Excel Range formatting to word Table formatting

Aspose.Cells Product Family
19

here is the excel file. I am trying to print only the named range called formattedTable

Adhirath Excel Doc.zip (25.9 KB)

20

@Adhirath ，

The other content is from the other sheet “Sheet2”, please use the following code to hide all the worksheets except the worksheet where the specified range is in.

Workbook workbook ...

//hide all the sheet except the range sheet.
range.Worksheet.IsVisible = true;
foreach (Worksheet sheet in workbook.Worksheets) 
{ 
    if(sheet.Index != range.Worksheet.Index)
    {
        sheet.IsVisible = false;
    }
}

DocxSaveOptions saveOptions = new DocxSaveOptions();
workbook.Save(“C:\my\path\Adhirath Excel Doc.Docx”, saveOptions);
21

that helped, but I’m still getting an extra blank page in my word document. Can I do something about that ?

22

@Adhirath,

You may set the printable area for the worksheet in MS Excel manually and then take the print preview of the sheet in MS Excel to check that blank page is also displayed or not. Moreover, could you please share your sample (runnable) code using Aspose.Cells for .NET with resource files (please zip the files prior attaching here). We will check and assist you to accomplish the task for your requirements.

23

code-
Hi, this is the code I am using. For some reason other tables and charts are also showing up in the created document.
Workbook workbook = new Workbook(“C:\my\path\Adhirath Excel Doc.xlsx”);
Aspose.Cells.Range range = workbook.Worksheets.Names[RangeName].GetRange();
range.Worksheet.IsVisible = true;
foreach (Worksheet sheet in workbook.Worksheets)
{
if(sheet.Index != range.Worksheet.Index)
{
sheet.IsVisible = false;
}
}
Aspose.Cells.PageSetup pageSetup = range.Worksheet.PageSetup;
pageSetup.PrintArea = range.RefersTo;
DocxSaveOptions saveOptions = new DocxSaveOptions();
workbook.Save(“C:\my\path\Adhirath Excel Doc.Docx”, saveOptions);

I am trying to get only the range called foramttedTable, it ends up providing me an extra blank page when converted to doc.
Adhirath Excel Doc.zip (26.1 KB)

24

@Adhirath
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-57903

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

1 Like
25

Hi, so there is a range I manually created, it has borders and when i save the excel as docx, i am not getting those borders to show up. The print image look just fine when I open it in excel. what is the reason?

try 1 is the output, book1 is the source table
Book1.zip (11.9 KB)

Try1.zip (8.9 KB)

26

also recommend fixes so that I am able to replicate the table exactly the way it is in excel print page to my word document. Thanks!

27

@Adhirath
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-57925

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

28

@Adhirath
We are pleased to inform you that your issue (logged earlier as “CELLSNET-57903”) has been resolved. The fix/enhancement will be included in the next release (Aspose.Cells v25.3) scheduled for release first half of March (next month). You will be notified when the next version is published.

1 Like
29

@Adhirath,

This is to inform you that your issue (logged earlier as “CELLSNET-57925” - Show Borders when converting Excel to DOCX) has been resolved. The fix/enhancement will be included in the next release (Aspose.Cells v25.3) scheduled for release first half of March (next month). You will be notified when the next version is published.

30

Thank you guys, amazing support !!

31

@Adhirath,

You’re welcome! Stay tuned—the next version is scheduled for release in the second week of March 2025.

32

@Adhirath
Attached file is generated by inner hot fix 25.2.3:
Net57925.docx (10.2 KB)

33

looks great!

34

@Adhirath,

Thanks for your feedback.

We will keep you updated as soon as the new version is released.

1 Like
35

Hi guys, ran into another issue, when i am trying to add a currency to my range instead of showing the currency i am getting another symbol, is there a fix for it?
my input range-
image.png (1.1 KB)

my output-
image.png (1.2 KB)

36

@Adhirath
Could you share a template file ? We will check it ASAP.

37

Excel doc (1).zip (13.8 KB)

38

@Adhirath
dest.docx (9.4 KB) is generated by 25.2.
We can not reproduce your issue with the following codes:

 Workbook workbook = new Workbook(dir + "Excel doc (1).xlsx");
 
 workbook.Save(dir + "dest.docx");