Unnecessary blank space while created_at, updated_at, deleted_at doesn't included in headings #4175
timotiushadi
started this conversation in
General
Replies: 1 comment 1 reply
-
https://docs.laravel-excel.com/3.1/exports/mapping.html#mapping-data |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Been reviewing some ways to configure out what's happen, yet still don't know if this by default or not.
So, I want to export a table, e.g Presence. In my table, I have a few field like hours_work, path and so on after these 3 fields: created_at, updated_at, deleted_at.
In headings function, I didn't set those 3 fields to go with in first row. Then I download in .xlsx, all going okay until it reached those 3 fields.
In 1st row, it looks like this: id, date_in, time_in, time_out, hours_work
but in 2nd row: 1, 31/07/24, 08:00:00, 16:00:00, blank, blank, blank, 6
Its giving me a blank column with null or no value. Looks like by default this is the reserve space for those 3 fields. How can I fix this?
Preview:
![image](https://private-user-images.githubusercontent.com/72373572/353748374-9f454879-0284-46f3-afb8-6e20385fcc18.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNzM2NjksIm5iZiI6MTczOTI3MzM2OSwicGF0aCI6Ii83MjM3MzU3Mi8zNTM3NDgzNzQtOWY0NTQ4NzktMDI4NC00NmYzLWFmYjgtNmUyMDM4NWZjYzE4LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDExMjkyOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWUwMTI4MTlkYzNkMDJlNTMwZGNmMTZkOGE2NGYxMTVkODg5MTE2MWVjOGQ0M2RjNGQxMzhhZDQ1ZmRjM2ViMTYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.3fYtP4kqX8L6IzMLWmA5CvzF5GGL8n8e9JpkhBKCPuA)
.xlsx:
vscode:
table:
![image](https://private-user-images.githubusercontent.com/72373572/353748707-0906b953-d6b0-4221-a640-1d6ede2ee954.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNzM2NjksIm5iZiI6MTczOTI3MzM2OSwicGF0aCI6Ii83MjM3MzU3Mi8zNTM3NDg3MDctMDkwNmI5NTMtZDZiMC00MjIxLWE2NDAtMWQ2ZWRlMmVlOTU0LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDExMjkyOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTljN2I3YjA5ODhkMmU1Y2M2MGQwYTk2N2JkYjdkOWM2OGMzMGY3MmRmZDU1ZTYxOTNhYmY0YWRiNjgxY2JlMzcmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.UD3bpiqSnHIxGYZeIrXYE7V8ukhxCaJllORWaRAqJu0)
Beta Was this translation helpful? Give feedback.
All reactions