Thanks guys this works well.
Don't supposed you also no the magic to make the loaded excel evaluate the formulas?
If not, what are the stratagies that I can use to calculate the foreign keys. It would be nice if the formulas could resolve ids across sheets. I would rather not have to hardcode them if I can avoid it.
On 5/25/06, Chris Nelson <cnelson4eii@xxxxxxxxx> wrote:
DBUnit can load the database from Excel files, but not
your domain objects. Sounds like a useful idea tho.
--- Edward Sumerfield <esumerfd@xxxxxxxxx> wrote:
> We are about to start building a cool idea for
> loading mock data into hsqldb
> and wondered if someone knows of a library that does
> it already?
>
> Each MS Excel file represents a set of mock test
> data, each worksheet name
> is the name of a Hibernate value object, each column
> name is the name of a
> setter method. We should be able to load the spread
> sheet, dynamically
> construct the objects, dynamically call the setters
> and insert into the db.
>
> --
> Ed
|