Great library  thanks to all who have worked so hard to put this together.
Is there any way to create a list and dataValidation?
I'd like to put a list on the second sheet, then grab the range to use for a listbox on the first sheet.
HSSFSheet sheet2 = hssfworkbook.GetSheet("Sheet2");
HSSFRow row = sheet2.CreateRow(0);
HSSFCell cell = row.CreateCell(4);
cell.SetCellValue("Product1");
row = sheet2.CreateRow(1);
cell = row.CreateCell(4);
cell.SetCellValue("Product2");
row = sheet2.CreateRow(2);
cell = row.CreateCell(4);
cell.SetCellValue("Product3");
something like:
HSSFName range = hssfworkbook.CreateName();
range.Reference = "Sheet2!$E1:$E3";
range.NameName = "range1";
and then use that list on sheet1.
Thanks for any help.
