Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Specify Formula Fields while Importing Data to Worksheet
Contents
[
Hide
]
Possible Usage Scenarios
You can specify formula fields when you import data into your worksheet using the ImportTableOptions.IsFormulas. This property takes a Boolean array where the value true means the field is a formula field. For example, if the third field is a formula field, then the third value in the array will be true.
Specify Formula Fields while Importing Data to Worksheet
Please see the following sample code that demonstrates how to specify formula fields while importing data into a worksheet. See the output Excel file generated by the code and the screenshot showing the effect of the code on the output Excel file.
Sample Code