That's easier then what I did. Using http://code.google.com/p/parsecsv-for-php/

Example code:
function opcerts_import_person() {
//add person
$csv = new parseCSV;
$csv->auto('/var/www/import.csv');

foreach ($csv->data as $key => $row) {
    //get the nid if the person already exists
    $nid = opcerts_person_check_emp_id($row['emp_id']);
    if (!$nid) {
      $person = new stdClass;

      //add person
      $person->uid = 1;
      $person->type = 'person';
      $person->field_last_name[0]['value'] = $row['l_name'];
      $person->field_first_name[0]['value'] = $row['f_name'];
      $person->field_emp_id[0]['value'] = $row['emp_id'];
      $person->field_position[0]['value'] = $row['title_tid'];
      $person->field_unit[0]['value'] = $row['unit_tid'];
      $person->field_middle[0]['value'] = $row['m_name'];
      $person->field_other_name[0]['value'] = $row['o_name'];
    }
    else {
      //add the unit to the person
      $person = node_load($nid);
      array_unshift($person->field_unit, array('value' => $row['unit_tid']));
    }
    node_object_prepare($person);
    node_save($person);
    unset($person);
}
}

Cheers,
Neil
http://code-dreamers.com

On Thu, Jul 30, 2009 at 1:19 PM, Kyle Mathews <mathews.kyle@gmail.com> wrote:

Feedapi + parser_csv + feed element mapper + cck

http://drupal.org/project/feedapi
http://drupal.org/project/parser_csv
http://drupal.org/project/feedapi_mapper

Kyle

Research Assistant
Entrepreneurship and Technology Center @ BYU
kyle.mathews2000.com/blog

2009/7/30 Gastón Pablo Pérez <gpperez@gmail.com>

Hi!

I would like implement a functionality in a web site for able to upload an excel file, with a determined format, and then, I want to generate nodes with this information.
Exists a module or a medium to do that? or how can i insert data into drupal database from an excel file?

thanks a lot

--
"La perseverancia es un árbol de raíces amargas, pero de frutos muy dulces."

Gastón Pablo Perez
Email:gpperez@gmail.com