1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| public class xlsx
{
static public double[,] xlsx_read(string FilePath )
{
double[,] maille;
FileInfo existingFile = new FileInfo(FilePath);
using (ExcelPackage package = new ExcelPackage(existingFile))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; // cible la premiere feuille du classeur
int col = 1;
var rowCnt = worksheet.Dimension.End.Row; //comptage des lignes
var colCnt = worksheet.Dimension.End.Column; //comptage des colonnes
double[,] temp = new double[rowCnt,8]; //matrice temporaire de 8 colonnes et de rowCnt lignes
maille = temp;
//Console.WriteLine(rowCnt);
for (int row = 1; row < rowCnt; row++)
{
if (worksheet.Cells[row, col].Value != null)
{
maille[row, 1] = (double)worksheet.Cells[row, 1].Value;// remplissage des x
maille[row, 2] = (double)worksheet.Cells[row, 2].Value;// remplissage des y
maille[row, 3] = (double)worksheet.Cells[row, 3].Value;// remplissage des z
maille[row, 4] = (double)worksheet.Cells[row, 4].Value;// remplissage des g
}
}
//Console.WriteLine(maille.Length);
//Console.WriteLine(maille[1,1]);
}
return maille;
}
} |
Partager