hi, team.
i need to start using xlsx for emailed attachments in workflows and reports. have had this problem everytime. unlucky did not find previous reports in the community,
then
todayโs xml from Excel reported repairs:
error345720_01.xml
thanks in advance for your help.
Solved! Go to Solution.
Can you submit a bug report for the problem?
When you do that, please provide the exact steps to recreate the problem.
It is often hard to reproduce a problem without very precise steps.
To often, I do something subtly different than you do, and then the I cannot reproduce the problem.
Having the exact repro steps saves me a lot of time and lets me solve the problem quicker.
I will need to debug it.
Please provide:
I am also facing this issue.
each time xlsx file is received from app, has to be opened in google sheets first and then downloaded as xlsx file from there.
Otherwise, it shows as "File format or file extension is not validโฆ Verify that file is not corrupted and the file extension matches format of the file. "
However, opens fine through google sheets and then can be downloaded.
Hi Shikanth,
Can you verify that you are using a Excel .xlsx file as the template?
If you are using an Excel .xlsx file as the template, then I will need to debug the problem and you should provide exactly the same information I asked for above.
No, I am using google doc as template. What is the best suited one for getting xlsx file as output, I am fine with any format as template.
You must use an Excel .xlsx file as the template if you wish to create an Excel .xlsx attachment.
Nothing else will work properly.
hi, Philip.
apologies for the delayed reply.
Finally, Philip, i get a repairs report by excel
-
error333000_01.xml
-
Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
-
Repaired Records: Format from /xl/styles.xml part (Styles)
Your original Excel template seems to be invalid.
When I try to open your original template, Excel complains that the Styles in the worksheet are invalid.
Excel then attempts to fix up your template.
You should either recreate the Excel template file or fix the problems in it.
ok, Phil, but the template was created in/by appsheet Create button:
i will be making many more of these XLSX, i planned to created all my templates within appsheet, can appsheet create the template without styles, as you suggest?
And, furthermore, just in case of doubt, i always edit these XLSX in google sheets, iโm not downloading a copy to edit then uploading it.
I am not sure I understand. Are you really editing the .xlsx files in Google Sheets?
I would suggest editing the templates using Excel and not Google Sheets.
Editing .xlsx files in Google Sheets adds a whole new level of potential problems.
well, yes, @Phil ,
the xlsx files I use for Appsheets attachment templates are created by / inside Appsheets using the โCreateโ button in the Behaviour>Reports>Attachment Template area.
Then I edit the template with the โViewโ button next to that, which seems solid logical.
is this all the wrong thing to do?
when you say โEditing .xlsx files in Google Sheets adds a whole new level of potential problems.โ
are you recommending that i create xlsx files locally on my PC or only edit them after download to my PC, then upload to Google Drive, then link to Appsheets to use them?
this does not make sense to me.
I recommend that you keep the templates in Excel at all times.
Here is what I do:
thanks, @Phil .
Even a freshly appsheet-created xlsx attachment template immediately downloaded to my PC gives errors:
i click Yes, then Enable Editing, gives me this error:
the excel list of repairs says:
the untouched template is:
TESO-751911 Content
PAYROLL REPORT BY STATE SURVEYOR START_AttachmentTemplate_20200220_023132.xlsx
if this is not happening to others, how do I fix this at the point of appsheet creation?
cheers, Mike.
Try a non appsheet created one.
Why not use google sheets?
thanks, @Jonathan_S and @Phil
i hope to continue using the create feature in appsheet, it should be the best option.
Iโm not stuck with this problem. But I think there is a bug here that should be addressed.
it feels best practice and iโve been very happy to let appsheet create the xlsx attachment template in Drive, then edit in Google Sheets. No download/upload steps has to be better.
Further, unlike @ Srikanth_S my users can only open the xlsx attahment in Outlook, hence will always get the errors.
For this particular template, as you said, @Phil, i downloaded the raw appsheet-created xlsx attachment template, you do not say if you get the errors, i let Excel โfixโ them saved that over the original and uploaded to Drive, this attachment does not give errors anymore.
But the root question is if no one else gets this error, while I and a few others do?
if so, there is a problem with appsheet creating some xlsx attachment templates.
Significantly, another appsheet created xlsx template never gave me the errors, here:
TESO-751991/Content
INVOICING REPORT BY JOB DOCKET_AttachmentTemplate_20200211_214016.xlsx
i think this needs to be fixed.
Cheers.
Can you submit a bug report for the problem?
When you do that, please provide the exact steps to recreate the problem.
It is often hard to reproduce a problem without very precise steps.
To often, I do something subtly different than you do, and then the I cannot reproduce the problem.
Having the exact repro steps saves me a lot of time and lets me solve the problem quicker.
thanks, @Phil
I agree, will do my best to reproduce and document.
This is an old thread and Iโm not sure if this will help others.
I was getting this error. I fixed it by formatting the cell in the template. My date in the row was causing the error.
In the end I made the template in excel, formatted the date cell to date. Uploaded it to My Drive and done. I would assume you could do the same thing with a sheets file.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |