ImportHtmlTable with formula columns

[Sunil]

Hi,

I am trying to import data into XL using ImportHtmlTable() method. One of the columns has formula, which is not getting imported as formula. here is the sample html table

<table>

                        <tr>

                            <td>SM</td>

                            <td>Customer</td>

                            <td>2021 Estimate</td>

                            <td>%</td>

                            <td>CSR</td>

                        </tr>

                    <tr>

                        <td>BS</td>

                        <td>Customer 1</td>

                        <td>0</td>

                        <td>=C2+C303</td>

                        <td>MA</td>

                    </tr>

</table>

Any solution please on how to import this data and let Excel auto consider that column as formula?

Thanks,

Sunil

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Sunil, 

Greetings from Syncfusion. 

We are checking the query and will get back to you with details tomorrow. We appreciate your patience. 

Regards, 

Keerthi. 

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Sunil, 

We appreciate your patience. 

As of now we do not have support for importing HTML table with formulas into Excel worksheet. However, we have considered your request and logged a feature report as “Import HTML table with formulas into Excel worksheet”. But we do not have any immediate plans to implement this feature in near future. You can track the status of this feature report through following feedback link. 

Track Status: https://www.syncfusion.com/feedback/32358/import-html-table-with-formulas-into-excel-worksheet 

Regards, 

Ramya. 

 

[Sunil]

thanks Ramya for the update!

Thank you!

Sunil

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Sunil, 

You are Welcome. 

Regards, 

Keerthi.