Hi,I am trying to use the Excel engine with an Excel spreadsheet I use that has Named References. Basically, I need to select the cell that has the Named Reference and insert a value. Using OLE automation I currently use:
How would I do this with the Excel engine?
Similar to this, I also need to move to a Named Reference or select a specific cell to start outputting data or format the cell. Currently I use something like:
Sheet.Range("A4:J4").Select()Excel.Selection.Font.Bold = TrueExcel.Selection.Font.Italic = True
How would I handle this?
Thanks
The Excel assembly currently offers no way of using named reference data when modifying the worksheet. You can submit a feature request for this here: http://devcenter.infragistics.com/Protected/RequestFeature.aspx.