Hello Thanks for the sample ... Same argument could be held for fluent files. Almost any data analysis and processing includes an excel document somehow ... So, it would be great to have it right in the package along with Fluent Files. Consider it as an add-on !
On May 31, 5:17 pm, Nathan Palmer <[email protected]> wrote: > I've never been a big fan of having Excel part of an Etl process. > There are too many reasons for it to fail when you are dealing with so > many features and formatting and don't forget user manipulation of the > data. With that said though you could integrate that excel package > into the pipeline of Rhino ETL pretty easily. > > using (ExcelPackage xlPackage = new ExcelPackage(existingFile)) > { > // get the first worksheet in the workbook > ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets[1]; > > for (int iRow = 1; iRow < 6; iRow++) > { > yield return Row.FromObject(new > { > FirstName = worksheet.Cell(iRow, 1).Value, > LastName = worksheet.Cell(iRow, 2).Value > }); > } > > } > > Nathan Palmer > > On Mon, May 31, 2010 at 3:19 AM, jalchr <[email protected]> wrote: > > Hello, > > I think adding support for Excel processing would be a great addition > > to Rhino.ETL .... fortunately, here is a managed library to work with > > excel > >http://excelpackage.codeplex.com/ > > > I think the Project leader should have a look at this > > > -- > > You received this message because you are subscribed to the Google Groups > > "Rhino Tools Dev" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group > > athttp://groups.google.com/group/rhino-tools-dev?hl=en. -- You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en.
