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 at
> http://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.
