I have a customer that wants data from excel printed onto a crystal report. They want the row of data sent the the crystal report at a time. I have created a component that can be called from VBA within excel and sends the data to the report for printing. My problem is sending only one row of data from excel to that component at a time. I was thinking to do so by obtaining the row int (Rows(“8:8”)) and sending that value to the component, however I do not know how to then select only a specific row of and excel sheet from C#? Can anyone help? Also, is there there a better way? Perhaps sending the row to the .rpt file directly from VBA within excel.
Any thoughts are most appreciated.
