My user has an xls that has some confidential data. I want to use it in Koolreport as a datasource.I am using codeigniter so I have set up a form where the user picks the xls file from their hard drive, and then I transfer it up to my server using

  $data = array('upload_data' => $this->upload->data());   <<this uploads the file to the server

  $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader("Xls");
  $reader->setReadDataOnly(true);
  $file = $data["upload_data"]["full_path"];
  $spreadsheet = $reader->load($file);

So far so good. My site uses https and I use AWS RDS. So once I get the table up to my server, the environment is pretty secure, I think.

The next stage is do some processing on it and then to write it out row by row to a mysql table. So I need to be able to go through the datastore, row by row, and insert into a mysql table. Is there any example of doing this?