All Questions
206
questions
0
votes
2
answers
53
views
How to solve ERROR - Failed to fetch Excel data. Unable to verify username?
hi I have a code of a telegram bot I am trying to connect it to a Excel file. The code is of Bot taking input and updating it to the excel worksheetk the error is // 2024-07-14 11:27:16,343 - main - ...
1
vote
2
answers
99
views
Error deploying app services on Azure with Python 3.9 and Flask to process Excel files
I have the following environment deployed from VS Code
enter image description here
It was deployed in App Services on Azure using Python 3.9 and Flask to create an application on a B1 plan (Total ACU:...
0
votes
1
answer
82
views
how to mask hash users into random values [email protected] in azure databricks
We have an Excel file in file store that contains more than 10,000 columns of JSON data in each excel file.
for example, a sample like below.
json:
{"SearchName":"","Id":&...
0
votes
1
answer
101
views
Using Azure Logic Apps to validate excel documents and move them to different folders in Sharepoint?
It's been a while since I used Azure Logic Apps but I've got a use case for a client where we need a (stage) landing place for excel data (probably sharepoint) but before we ingest that data into our ...
- 19
1
vote
0
answers
77
views
Excel VBA Error with user access Permission.Add
I wrote the following Excel macro to assign user permissions to Excel files.
Sub Add_Permission()
Dim objUserPerm As Office.UserPermission
Set objUserPerm = ActiveWorkbook.Permission.Add("...
- 11
0
votes
1
answer
63
views
Update Python code to do Text to Columns action with Azure Function App
I'm using an Azure Function App with Python that converts csv to xlsx. This works fine however, the StartDate and LeaveDate column data appears on the left side of the columns which tells me its not ...
0
votes
1
answer
103
views
Azure and VSTO Addin - Could not load file or assembly 'System.Diagnostics.DiagnosticSource, Version=6.0.0.0,
I'm really stumped on this one. I am trying to call the Azure Form Recognizer from within a VSTO Excel add-in, uploading a local document to be analyzed and I have been getting all sorts of errors.
...
- 1
0
votes
1
answer
58
views
Calling Azure Document Intelligence API inside VSTO Excel Addin
It's likely a result of my lack of knowledge about VSTO addins, but I am unable to get Azure Document Intelligence calls to work at all from within the application. I made a regular console app, just ...
- 1
0
votes
1
answer
70
views
azure function app connection to postgresql
const { app } = require('@azure/functions');
const ExcelJS = require('exceljs');
const { Pool } = require('pg');
app.storageBlob('storageBlobTrigger', {
path: 'attachments/{name}',
connection:...
0
votes
0
answers
50
views
Azure Batch for Excel VBA
Is there any way to run Excel VBA using a batch service in Azure?
My company has many large Excel VBA engineering calculations that are run on a regular basis. I am looking at ways to run these ...
0
votes
0
answers
38
views
Using Power Automate to connect my Excel inputs to Azure ML Studio API endpoint and do predictions
I am figuring out how I can use Power Automate to configure a flow which can connect my Excel file inputs with my Azure ML Studio API endpoint. Ideally this flow will be triggered when one of my ...
- 1
0
votes
1
answer
86
views
How do I install Excel using Azure CLI
I have an Azure Subscription, API Management service, App Service, and Resource group.
My website allows people to upload their information in Excel spreadsheets, parses them, and then generates ...
- 817
-1
votes
1
answer
293
views
Copy excel file from Sharepoint to Azure DLS with Logic app and keeping excel formatting
I use a Azure Logic app to copy excel files from a Sharepoint folder into a Datalake storage account. From here I use ADF to copy the data into an SQL DB.
Some values in the excel files have ...
- 37
0
votes
1
answer
56
views
Python openpyxl - recording != match cells in a comparison
I'm comparing data between two Excel workbooks and recording the hits in a third.
This is Azure-Provider-description.xlsx:
This is Azure-Scrape.xlsx:
And this is Azure-Actions:
And here's the code:
...
- 89
0
votes
1
answer
104
views
Azure Data Factory using Blob and package located in a Managed Instance
I have an Azure Managed Instance and also deployed an Azure Data Factory V2 for one of our clients.
My doubt right now is about one request from the client regarding execute a package SSIS but one ...
