Create a workbook Example not working

[Djone124]

Could not get the example provided in the section Create a workbook with a Base64 example to function. It is saying the property result does not exist for "event.target". The code is being run in Script Lab.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: c6b16473-fffd-9ebf-ee91-2f0012a496ee
• Version Independent ID: 3f147de9-0138-9104-f462-c6f4097b1167
• Content: Work with workbooks using the Excel JavaScript API - Office Add-ins
• Content Source: docs/excel/excel-add-ins-workbooks.md
• Product: excel
• Technology: add-ins
• GitHub Login: @o365devx
• Microsoft Alias: o365devx

[kbrandl]

@Djone124 sorry to hear that you've run into this problem. @AlexJerabek is this something that you can investigate? Thanks!

[AlexJerabek]

Hi @Djone124 ,

Thanks for reporting this. If you're using Script Lab, there's a full TypeScript example for this scenario in Script Lab's samples. You'll see there's some casting to get this to cleanly compile, but the JavaScript should work anyway. Try that out and let me know if there are still problems.

That said, I should clean up the JavaScript in this sample. The type of event.target is ambiguous. According to this comment, we'll get the same behavior by calling reader.result.toString(). I'll update the code in both the docs and Script Lab to do that and avoid the need to cast.

As for the compilation error for myFile.files[0], you'll have to cast it in TypeScript. We do that in the Script Lab sample, but can't really the in the JS sample.

I'm going to open PRs in this repo and office-js-snippets for the code changes described above. Please let me know if you're able to get the sample working in Script Lab.

[Djone124]

Hello Alex, Thank you! I was able to get the sample to work perfectly. I must have glanced right over that sample in the Samples pane in Script Lab. I really appreciate the help, Danny

…

On Tue, Sep 3, 2019 at 11:05 AM Alex Jerabek ***@***.***> wrote: Hi @Djone124 <https://github.com/Djone124> , Thanks for reporting this. If you're using Script Lab, there's a full TypeScript example for this scenario <https://github.com/OfficeDev/office-js-snippets/blob/master/samples/excel/50-workbook/create-workbook.yaml> in Script Lab's samples. You'll see there's some casting to get this to cleanly compile, but the JavaScript should work anyway. Try that out and let me know if there are still problems. That said, I should clean up the JavaScript in this sample. The type of event.target is ambiguous. According to this comment <microsoft/TypeScript#4163 (comment)>, we'll get the same behavior by calling reader.result.toString(). I'll update the code in both the docs and Script Lab to do that and avoid the need to cast. As for the compilation error for myFile.files[0], you'll have to cast it in TypeScript <https://stackoverflow.com/questions/33460430/get-a-htmlinputelement-type-in-typescript>. We do that in the Script Lab sample, but can't really the in the JS sample. I'm going to open PRs in this repo and office-js-snippets <https://github.com/OfficeDev/office-js-snippets> for the code changes described above. Please let me know if you're able to get the sample working in Script Lab. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#1276?email_source=notifications&email_token=AFY56WI7NJOIPQ4E7S4WTNTQH2ROHA5CNFSM4ISV5ZHKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD5ZB45I#issuecomment-527572597>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFY56WKGK2FHCBKCQNYYWNDQH2ROHANCNFSM4ISV5ZHA> .

-- *Daniel J. O'Neil III* Analyst at Probability Management Phone: (916) 821-0549 Email: [email protected] Link to Linkedin Profile <http://www.linkedin.com/in/danieloneil124>

[AlexJerabek]

Hi Danny,
I'm glad everything's working. I'm going to go ahead and close the issue, as the doc changes are in the pipeline. If you encounter any other problems while developing your add-in, please reply to the thread or create a new issue.
Thanks!