Handling of Nested Objects, when exporting to xlsx

[anishshobithps]

Firstly, thank you for this and example set, it helped me a lot.

I had a situation where, I was fetching details from the database, and it had a nested Object, but the export part would only export non-nested fields.

I was able to achieve exporting nested Object, with the help of by changing

React-Advance-Table/lib/exportExcel.ts

Lines 19 to 23 in 12fb077

	for (const objKey in obj) {
	if (Object.hasOwn(naming,objKey)) {
	tempObj[naming[objKey]] = obj[objKey];
	}
	}

To

		Object.keys(obj).forEach(key => {
			if (typeof obj[key] === "object") {
				Object.keys(obj[key]).forEach(nestedKey => {
					if (naming[nestedKey]) {
						tempObj[naming[nestedKey]] = obj[key][nestedKey];
					}
				});
			} else {
				if (naming[key]) {
					tempObj[naming[key]] = obj[key];
				}
			}
		});

[mjm918]

Hi @anishshobithps thanks for the improvement. can you create a PR? i will merge it. Your changes will help someone ☺️

[anishshobithps]

Firstly, thank you for this and example set, it helped me a lot.

I had a situation where, I was fetching details from the database, and it had a nested Object, but the export part would only export non-nested fields.

I was able to achieve exporting nested Object, with the help of by changing

React-Advance-Table/lib/exportExcel.ts

Lines 19 to 23 in 12fb077

	for (const objKey in obj) {
	if (Object.hasOwn(naming,objKey)) {
	tempObj[naming[objKey]] = obj[objKey];
	}
	}

To

		Object.keys(obj).forEach(key => {
			if (typeof obj[key] === "object") {
				Object.keys(obj[key]).forEach(nestedKey => {
					if (naming[nestedKey]) {
						tempObj[naming[nestedKey]] = obj[key][nestedKey];
					}
				});
			} else {
				if (naming[key]) {
					tempObj[naming[key]] = obj[key];
				}
			}
		});

Found out that if something doesn't have a nested object it fails, I have a fix for it but I am busy this week with work, will have a PR for it by the end of the week.

[MarcosVini9999]

@anishshobithps What would be the solution to this failure? thanks

[anishshobithps]

@MarcosVini9999, I never got a chance to work on it and fix the issue and totally forgot about the issue after the work, but you can find the code where I used it or fixed at : https://github.com/tiarasjec/website/blob/main/src/lib/exportExcel.ts I hope that helps

[MarcosVini9999]

@anishshobithps Thanks

here the code for this table

export function exportExcelData<T>(rows: T[], columns: Column<T>[], excludeColumns: string[]): T[] {
  const data: T[] = [];
  const naming: { [k: string]: any } = {};

  for (let i = 0; i < columns.length; i++) {
    const col = columns[i];
    if (excludeColumns.length > 0 && excludeColumns.includes(col.id)) {
      continue;
    }
    naming[col.id] = col.columnDef.header;
  }

  const getNestedProperty = (obj: any, path: string) => {
    return path.split(".").reduce((acc, part) => acc && acc[part], obj);
  };

  rows.forEach((item) => {
    const obj = item as { [K: string]: any };
    const tempObj: { [k: string]: any } = {};

    for (const namingKey in naming) {
      const value = getNestedProperty(obj, namingKey);
      if (value !== undefined) {
        tempObj[naming[namingKey]] = value;
      }
    }

    for (const objKey in obj) {
      if (typeof obj[objKey] === "object" && obj[objKey] !== null) {
        for (const nestedKey in obj[objKey]) {
          const fullKey = `${objKey}.${nestedKey}`;
          if (Object.hasOwn(naming, fullKey)) {
            tempObj[naming[fullKey]] = obj[objKey][nestedKey];
          }
        }
      }
    }

    data.push(tempObj as T);
  });

  return data;
}

[mjm918]

@MarcosVini9999 can you create a PR? it will be helpful for others 😊