亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

As mentioned, have any friends encountered similar problems?

// Instantiate a new PHPExcel object
$objPHPExcel = new PHPExcel(); 
// Set the active Excel worksheet to sheet 0
$objPHPExcel->setActiveSheetIndex(0); 
// Initialise the Excel row number

$objPHPExcel->getActiveSheet()->setCellValue("A1","下單日");
$objPHPExcel->getActiveSheet()->setCellValue("B1","銷售區(qū)域");
$objPHPExcel->getActiveSheet()->setCellValue("C1","銷售組");
$objPHPExcel->getActiveSheet()->setCellValue("D1","銷售姓名");
$objPHPExcel->getActiveSheet()->setCellValue("E1","項(xiàng)目號(hào)");
$objPHPExcel->getActiveSheet()->setCellValue("F1","客戶");
$objPHPExcel->getActiveSheet()->setCellValue("G1","訂單號(hào)");
$objPHPExcel->getActiveSheet()->setCellValue("H1","訂單行次");
$objPHPExcel->getActiveSheet()->setCellValue("I1","物料號(hào)");
$objPHPExcel->getActiveSheet()->setCellValue("J1","物料描述（英文）");
$objPHPExcel->getActiveSheet()->setCellValue("K1","銷售單位");
$objPHPExcel->getActiveSheet()->setCellValue("L1","訂單總數(shù)量");
$objPHPExcel->getActiveSheet()->setCellValue("M1","未發(fā)貨數(shù)量");
$objPHPExcel->getActiveSheet()->setCellValue("N1","已發(fā)貨數(shù)量");
$objPHPExcel->getActiveSheet()->setCellValue("O1","確認(rèn)庫存數(shù)量");
$objPHPExcel->getActiveSheet()->setCellValue("P1","要求出庫日");
$objPHPExcel->getActiveSheet()->setCellValue("Q1","預(yù)計(jì)出庫日");
$objPHPExcel->getActiveSheet()->setCellValue("R1","發(fā)貨倉庫");
$objPHPExcel->getActiveSheet()->setCellValue("S1","發(fā)貨凍結(jié)");
$objPHPExcel->getActiveSheet()->setCellValue("T1","發(fā)貨凍結(jié)");
$objPHPExcel->getActiveSheet()->setCellValue("U1","發(fā)貨單號(hào)");
$objPHPExcel->getActiveSheet()->setCellValue("V1","運(yùn)輸條件");
$objPHPExcel->getActiveSheet()->setCellValue("W1","訂單狀態(tài)");



$row11Count = 2; 
// Iterate through each result from the SQL query in turn
// We fetch each database result row into $row in turn
while($row11 = mysqli_fetch_array($result11)){ 
    // Set cell An to the "name" column from the database (assuming you have a column called name)
    //    where n is the Excel row number (ie cell A1 in the first row)
    $objPHPExcel->getActiveSheet()->SetCellValue('A'.$row11Count, $row11['?Created on 下單日']); 
    // Set cell Bn to the "age" column from the database (assuming you have a column called age)
    //    where n is the Excel row number (ie cell A1 in the first row)
  $objPHPExcel->getActiveSheet()->SetCellValue('B'.$row11Count, $row11['SalesOffice']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('C'.$row11Count, $row11['SalesGroup']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('D'.$row11Count, $row11['Sales group descript 銷售姓名']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('E'.$row11Count, $row11['WBS']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('F'.$row11Count, $row11['Customer name 客戶名']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('G'.$row11Count, $row11['Order No. 訂單號(hào)']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('H'.$row11Count, $row11['Line 訂單序號(hào)']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('I'.$row11Count, $row11['Material 物料號(hào)']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('J'.$row11Count, $row11['Item Description 物料描述']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('K'.$row11Count, $row11['Unt 銷售單位']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('L'.$row11Count, $row11['Ordered Qty 訂單數(shù)量']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('M'.$row11Count, $row11['Opn.Qty.Dlv 未發(fā)數(shù)量']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('N'.$row11Count, $row11['Deliv. Qty. 已發(fā)數(shù)量']); 
  $objPHPExcel->getActiveSheet()->SetCellValue('O'.$row11Count, $row11['Conf Stock Qty 確認(rèn)庫存數(shù)量']); 
 $objPHPExcel->getActiveSheet()->SetCellValue('P'.$row11Count, $row11['Req.Date 要求出庫日']);
  $objPHPExcel->getActiveSheet()->SetCellValue('Q'.$row11Count, $row11['Conf.dat(ETD) IL 預(yù)計(jì)出庫日']);
   $objPHPExcel->getActiveSheet()->SetCellValue('R'.$row11Count, $row11['SupPlnt 發(fā)貨倉庫']);
    $objPHPExcel->getActiveSheet()->SetCellValue('S'.$row11Count, $row11['Delivery Block 發(fā)貨凍結(jié)']);
     $objPHPExcel->getActiveSheet()->SetCellValue('T'.$row11Count, $row11['Dlv No 發(fā)貨單號(hào)']);
 $objPHPExcel->getActiveSheet()->SetCellValue('U'.$row11Count, $row11['Shipping condition']);
  $objPHPExcel->getActiveSheet()->SetCellValue('V'.$row11Count, $row11['Shipping point']);
   $objPHPExcel->getActiveSheet()->SetCellValue('W'.$row11Count, $row11['Order status 訂單狀態(tài)']);

    // Increment the Excel row counter
    $row11Count++; 
} 

// Instantiate a Writer to create an OfficeOpenXML Excel .xlsx file
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); 
// Write the Excel file to filename some_excel_file.xlsx in the current directory
$objWriter->save('OP.xlsx'); 



echo "<a href='./OP.xlsx' download='OP.xlsx'>另存為Excel</a>";

mysqli_close($link);  //關(guān)閉連接