mbrn / filefy Goto Github PK

Write documentation in readme file

I'm working with material table and on my table, there are some filters by date. When I export the data, I need the user to see what they filtered the table, like 'today' or 'yesterday' and a title for the document, which is the page title.

My question is, how can I add a row before the columns name row?

Architecture shuld be abstracted that file generators and different file format generators should be added later easily.

A default value of , can be set if required. Something like:

constrcutor(fileName: string, delimiter: strinng = ",") {

mbrn/material-table#286

Excel export should be available.

I am using this package in my ReactJS code with material-table. In the exported CSV, all values are enclosed within double quotes. (see below)

All I want is to export the table as a tab delimited values and I DON'T want these values enclosed in double quotes. If I open the exported file and save as tab delimited file, I can see MS-Excel is removing double quotes.

"Title","First Name","Last Name","Address Line 1","Address Line 2","City","State","PostCode","Phone","Mobile","Fax","Email","Company","Order Number","Primary Campus","Category","Permit Type","Receipt Number","Staff\Student ID","Rego No","Make","Alt Rego No","Alt Make","Validations Errors","Warnings"
"","Greg Turnbull","Odgers","14 Empire St","","Poke","AB","C2750","","90909090","","[email protected]","","897878723","Hando",,"General Half Year ","WEB181224","47","8987723","yywte","Mazda 3","iouuu","",
"","Bob","Gaunder","222 CAT drive","","Nona","CT","D2126","","8977776","","[email protected]","","89898","Jacksonville",,"General Annual ","WEB181226","94","787233","FFR782","nissan","","",

<MaterialTable
title="Validation Results"
icons={tableIcons}
columns={columns}
data={applicationList}
options={{
exportButton: true,
exportAllData: true,
exportDelimiter: " ",
exportCsv: (columns, applicationList) => {
const repoColumns = columns.filter(columnDef => {
return !columnDef.hidden && columnDef.field && columnDef.export !== false;
});

                  let data = applicationList.map(rowData =>
                      columns.map(columnDef => {
                        return columnDef.render ? columnDef.render(rowData) : rowData[columnDef.field];
                      })
                    );
                    
                    alert('You should develop a code to export ' + data + ' rows');
                    new CsvBuilder(fileName+"_01")
                        .setDelimeter(',')
                        .setColumns(columns.map(columnDef => columnDef.title))
                        .addRows(data)
                        .exportFile();
                  },
                  showTitle: false,
                  isLoading: true,
                  //exportDelimiter: '        ',
                  headerStyle: {
                    backgroundColor: "#01579b",
                    color: "#FFF",
                  },
                  rowStyle: (rowData) => ({
                    color: rowData.errors !== "" ? "red" : "",
                  }),
                }}
                editable={{
                  onRowUpdate: (newData, oldData) =>
                    new Promise((resolve, reject) => {
                      setTimeout(() => {
                        const dataUpdate = [...applicationList];
                        const index = oldData.tableData.id;
                        dataUpdate[index] = newData;
                        setApplicationList([...dataUpdate]);

                        resolve();
                      }, 1000);
                    }),
                }}
              />

In CsvBuilder.ts the function escapeCell() is making the following call to insert "escapes" (presumably) for all occurrences of double-quote found in the "cell value" passed in:

private escapeCell(cellData: string): string { if(typeof cellData === 'string') { return '"' + cellData.replace('"', '""') + '"'; } return cellData; }

The replace currently will only replace the first occurrence of a double-quote encountered in the cellData; later, this leads to rendering problems in the spreadsheet. I tested the following change on my own system:

   return '"' + cellData.replace(/\"/g, '""') + '"';

Seems to work fine (fixed my spreadsheet issue anyway). Sorry I am not providing a link to a codepen or such; I am a newbie and it would take me a little time to get the hang of that, and I am short on time at the moment. I just wanted to bring this one to attention as we are trying to use the CSV Builder in conjunction with Material Table in our project. I would be glad to submit a PR if that works best for all of you.

Please advise...

The output CSV doesn't quote values, resulting in some weird output. (For exemple, if there is a line break in a cell, then it creates a new line in the file)

Fix:
In getRowData, replace all double quotes by a double double quotes (to escape it) and surround it with double quotes.

return row.map((data) => '"'+data.replace('"', '""')+'"').join(delimiter)

• recommendation to not use https://developer.mozilla.org/en-US/docs/Web/API/Navigator/msSaveOrOpenBlob

Configure travis to auto deploy

The if statement for window.navigator.msSaveOrOpenBlob in the BaseBuilder class is not followed by an else statement. Both bracketed regions are executed.

Filefy can't import to my TypeScript project. Or did I miss something?