Announcements
I have built an app which includes a button to launch an excel file. When I launch the excel in browser (Chrome), it opens fine and shows all the data I have already entered in the excel file. When I add Launch("ms-excel:ofe|u|"&"https://xxx") so the file opens in the Excel application, it shows up blank save the tab name. What can I do in the coding to show the data in the excel file?
Any suggestions?
Have you solved the problem? I have the same problem.
When I see my data in Dataverse or in the app, everything is fine. But when I open it with Excel, I only see a few columns, the rest is empty.
My current solution is to delete a row where I store images in JSON format. It seems that the JSON being too large (about 200000 characters) is causing the error. When I delete it, Excel works fine. Maybe the cell boundary is causing the error.
hey @Bulldog20
This issue might be related to how the file is being handled or accessed by the Excel desktop application when using the ms-excel:ofe|u| protocol handler.
Here are some steps you can take to troubleshoot and potentially resolve this issue:
Check the URL Format: Ensure that the URL you're using in the Launch command is correctly formatted and accessible. The ms-excel:ofe|u| protocol expects a properly encoded URL. If there are any special characters in your URL, they need to be URL-encoded.
Verify File Accessibility: Ensure that the Excel file is accessible at the given URL and that there are no permissions issues. If the file is stored on a cloud service (like SharePoint or OneDrive), make sure that the Excel application has the necessary permissions to access it.
Test with a Simple URL: Try using a simpler, publicly accessible URL to an Excel file to see if the issue is with the specific file or with the way the Launch command is being used.
Let me know if my answer helped solving your issue.If it did please accept as solution and give it a thumbs up so we can help others in the community.Greetings
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 337 Most Valuable Professional
11manish 173
Valantis 86
