IWorksheet Replace Method (String, DataTable, Boolean) |
Replaces specified string by data table values.
Examples
Examples
The following code snippet illustrates how to replace the string value with data table:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Replace the oldValue by data table</para><para>string oldValue = "Find";</para><para>System.Data.DataTable table = new System.Data.DataTable();</para><para>table.Columns.Add("Dosage", typeof(int));</para><para>table.Rows.Add(1);</para><para>worksheet.Replace(oldValue, table, true);</para><para>//Save to file</para><para>workbook.SaveToFile("Replace.xlsx");</para>
Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
void Replace( string oldValue, DataTable newValues, bool isFieldNamesShown )
Parameters
- oldValue
-
Type:
System
String
String value to replace. - newValues
-
Type:
System.Data
DataTable
Data table with new data. - isFieldNamesShown
-
Type:
System
Boolean
Indicates wheter field name must be shown.
See Also
