In an effort to streamline tasks in our office, I am working on automating certain processes. Specifically, this program is designed to log into our insurance company's website and extract information for payroll purposes. Below is the code snippet that I ...
My PHP script successfully generates an XML file from a database, but I'm encountering an issue with larger files. The table in the database has 53 columns. Excel can easily open a file with 7000 rows (20Mb), but once it reaches around 14000 rows (40Mb), ...
I need some help figuring out how to download an excel file from my vue.js project. I tried the following code: <template> <div class="row mt-5"> <a href="./assets/template.xlsx" target="_blank">Downloa ...
I've encountered an issue while trying to generate an .xlsx file using the XLSX library. The error message I received is as follows: TypeError: n.t.match is not a function at Ps (xlsx.full.min.js:14) at Jd (xlsx.full.min.js:18) at Sv (xlsx.full.min ...
I am currently faced with the task of reading an xlsx file that contains 10 by 5324 cells. This is essentially what I was attempting to achieve: from openpyxl import load_workbook filename = 'file_path' wb = load_workbook(filename) ws = wb.get ...
I'm currently working on a Python script to standardize Excel files using openpyxl. The code is almost finished, but I'm facing some challenges when attempting to achieve two specific tasks: For columns A & B starting from row #7, I need to me ...
Within my Laravel project, I have implemented the functionality to import data from Excel files in .CSV format. Interestingly, when I try to upload a small amount of data (around 15 or 10 entries), the import process works smoothly without any issues. Howe ...
Currently, I am attempting to export a pandas DataFrame into multiple Excel sheets with sheet names based on the "Service Type" column. Within my function, I'm implementing code to iterate through each column in the Excel worksheets and dynamically a ...
Is there a way to send values to specific cells in an Excel file stored on my webserver and then extract the result from another specific cell using PHP? ...
I have been attempting to add a new sheet to an existing excel file while preserving the current content within it. Despite trying various methods, I keep encountering the same error message. Whenever I attempt to write to or save the file, I receive an At ...
Having trouble reading an Excel file and printing results with a specific value in the column filter containing em-dashes/hyphens. Any other column filter value works fine. Looking for assistance to make this query work. The Excel file data is shown below, ...
I am new to automating tasks in Python involving Excel. I need assistance with extracting specific numbers that are surrounded by different characters within columns. Actual DATA Column A kDGK~202287653976 ~LD ~ 8904567 SIP~1233 ...
I want to achieve the following: Retrieve the value of an active cell (a property address) Launch Edge using a Selenium Edge Driver to go to www.redfin.com Search for the value from the cell (the property address) Capture the URL from the search re ...
After developing a node.js script to convert an array object into CSV format using the "objects-to-csv" library from NPM, I encountered an issue when opening the generated CSV file in WPS and Microsoft Office. The warning suggested that there was either an ...
I've got an excel spreadsheet that contains links to local folders. In order to optimize its compatibility with various devices, I convert it to HTML format. Everything seems to be working smoothly, except for one minor issue - when clicking on the li ...
Can someone help me identify the source of this error that I'm encountering while trying to generate an excel file? Fatal error: Uncaught Error: Call to undefined method PHPExcel::sheetNameExists() in /public_html/docs/PHP/PHPExcel/Worksheet.ph ...
I encountered an issue while attempting to write two strings to an Excel sheet using the following code. The error message I received was: java.lang.IllegalArgumentException: Sheet index (0) is out of range (no sheets) FileOutputStream fout=new FileOutput ...
I have a large block of text with various lines like: ksjd 234first special 34-37xy kjsbn sde 89second special 22-23xh ewio 647red special 55fg dsk uuire another special 98 another special 107r green special 55-59 ewk blue special 31-39jkl My goal is to ...
I am venturing into the world of web scraping for the first time using VBA. My goal is to extract pricing information from our company's distributors and save it in an Excel file for our sales team to analyze. The process involves taking the URL from my w ...
Objective I want to open a CSV file using Office365's Excel without actually saving the file on the client's machine. Challenge The issue with saving raw data on the client's machine is that it leads to clutter with old Excel files accumulating over tim ...
I'm currently dealing with VBA code in an Excel module that looks like this: Function getDescription(ByVal pCode As String) As String Dim oRequest As Object Set oRequest = CreateObject("WinHttp.WinHttpRequest.5.1") oRequest.Open "GET", "https: ...
At this moment, the loop I am executing successfully retrieves the necessary values. However, I am facing challenges when it comes to inserting these array values into a range of cells. I keep encountering the following error message: Error message: "The ...
I'm using this example to export a worksheet from https://github.com/SheetJS/js-xlsx/issues/817. How can I apply cell styling such as background color, font size, and adjusting the width of cells to fit the data perfectly? I have looked through the docum ...
Extracting the highest value of "id" from a JSON data string without iterating can be challenging. The given JSON data string is as follows: "ball_coordinates": [ { "id": 3938706, ...
When I create a new sheet, it works fine. However, when I try to call the same method to create another sheet, it overrides the previous one. After multiple method calls, only the last sheet is showing up. Each time, I am creating a new sheet and not a ne ...
I currently have two tables on hand: Accessory Request Table Accessory Details Table It's worth noting that one accessory request can have multiple entries in the accessory details table. However, when I attempt to export the data, only information ...
Looking for a solution to update an Excel spreadsheet monthly and display it on a Blackberry browser? I've already built a website with all the spreadsheet information using HTML lists and CSS for charts. I need help loading a new spreadsheet into th ...
Looking for a JavaScript solution to export HTML tables to Excel. I attempted a script that exports tables, but it stops when encountering special characters like '#'. Can someone assist me with this issue? Thank you in advance. <script src="/tpComm ...
Having an element with the following HTML: <span id="ContentPlaceHolder1_Label2" designtimedragdrop="1319" style="display:inline-block;color:Firebrick;font-size:Medium;font-weight:bold;width:510px;"></span> Upon clicking the Save button on ...
I have a challenge converting a large number of Excel Files, each with multiple sheets (some of them quite large), into .json files. To tackle this, I compiled a list containing the names of the sheets and then implemented a loop to generate a data frame f ...
I have a CSV file with data that is structured like this: After converting the CSV to JSON, the output looks something like this: { "Item1": "Data1", "Item2": "Data2", "Number1": 2209, "": 2210, ... and so on } However, I would like the JSON forma ...
I am using an Angular-based SPA for my web application. My goal is to be able to open an Excel file within the application itself. Currently, I have a menu button or link that is linked to a specific path, for example //192.168.10.10/sharedExcels/myExcel. ...
I've come across some other discussions on the same topic, but I haven't been able to find a clear answer. I would really appreciate it if someone could assist me with this problem. I'm trying to integrate RapidAPI into my VBA code in Excel to retrieve Wh ...
When using pandas to read an excel sheet and gather data from it in order to create a new excel document, there is a challenge. The current code only works if the user selects a sheet with the exact column name specified. It is necessary to verify that the ...
My goal here is to allow the user to input a starting and ending date. Upon clicking the 'Extract to Excel file' button, a query will be executed to select all columns from a table where the dates fall between the input DATEFROM and DATETO. Simul ...
Is it possible to make a button click work with the SPAN NG-IF feature? Am I approaching this issue incorrectly? The name "Lõuna port" changes when something else is clicked in the drop-down menu. I have a list of all the names but can't figure out how ...
When it comes to inserting data entries into the Common Data Service (CDS) Entity in PowerApps, I encountered an issue. My entity has a specific structure which is easy to work with when importing data from an Excel table. However, when trying to import da ...
Having some difficulties trying to access my webtext account through VBA. The first hurdle I faced was identifying the tags for the username and password input boxes. After using inspect elements, it seems like the tags are "username" and "password." Howe ...
Dealing with a variety of excel files can be challenging, especially when some are in disarray and with multiple sheets that I have no control over since they are provided externally. While I've successfully used xlsx-to-json for standard data rows, ...
Situation: I am in the process of developing an Excel Add-in with the OfficeJS library. The add-in utilizes ReactJS components and Office Fabric UI. With the use of OfficeJS, the user's selection can be integrated into the Excel sheet seamlessly. Cha ...
I am looking for a way to extract data in json format from each line of xlsx and csv files using AngularJS. Currently, I am utilizing the angular-file-upload library to access the file as shown below: $scope.LatLongUploader = new FileUploader({ //url ...
Just getting started with Selenium Web automation, so go easy on me. I've put together a method to write an array's content to an excel sheet. No errors or exceptions are popping up, but the data isn't showing up in the excel sheet as expec ...
I am seeking a way to organize the contents of an Excel file that includes the following data: 1.jpg CC Library - Screen for proxy.png aAd.ai aaa.PSD automation_35.jpg automation_36.jpg automation_37.jpg automation_371.jpg sad.psd sde-Recovered.ai sde-Rec ...
I'm looking to develop a spreadsheet similar to Google Sheets with user authentication. I've hit a roadblock on where to begin with this project as I'm unsure which NPM module to utilize. Would appreciate it if someone could steer me in the right directio ...
Recently, I've been working on a VBA script that scrapes company reporting dates from the London Stock Exchange website. However, I encountered an issue as they have made changes to their web query interface. So, I've been trying to tweak the scr ...
Is there a way to write the values of a variable on a Text or Excel sheet? I have a variable called tex that stores string values, and I want to output these values onto text files or an Excel sheet if possible. beforeEach(() => { cy.visit('https:/ ...
I am currently working on implementing VBA macros to retrieve real-time data from a website using API calls. To achieve this, I have incorporated the VBA-JSON library into my project. There are two main scenarios that arise when fetching the data: Scenari ...
If I possess an excel document that needs to be delivered to an API endpoint which demands the following headers: Content-Type: multipart/form-data Content-Disposition: form-data; name="fileData"; filename="Form_SOMETHING(2).xlsx" Is it plausible for me ...
Recently, I've encountered an issue with sending a match-function post request to an Excel workbook using the MS-Graph API. Instead of receiving the value of the first column that contains the lookup value, I'm getting the value from the second c ...
I need to execute a series of functions, each taking an item from a list as a parameter. Func1 will take the first list value, Func2 the second list value...and so forth. My current setup looks like this: main.py #import the 5 python files import s ...
I have recently developed a Rest API using the express framework that includes a route for exporting data. The information that needs to be exported to an excel file is currently stored in multiple arrays, and I want the excel file to have a specific prede ...
After extracting this data using Selenium in Python, I am looking to export it to an Excel file. I believe that pandas could be the solution, but I am unsure of how to accomplish this task. Any guidance would be greatly appreciated. Below is the code snip ...
I am currently working on printing a pandas data frame in an Excel sheet using openpyxl. So far, I have successfully printed the data frame with the default index. However, my question now is how can I print it without the default index. The code snippet b ...
Here is a piece of code I'm working on: #Code snippet in Python try: io = myElm.get_attribute("rel") print(io) except IndexError: d_io = myElm.get_attribute("data-outcome") print(d_io) except: print ...
My current progress: I have successfully used Selenium and my Python script to launch the browser, select specific fields, input text, and click submit. My desired goal: Instead of manually entering text, I want my Python script to iterate through an Ex ...
My current task involves loading a workbook and extracting its data with openpyxl on a Windows system. I am facing the challenge of needing to access the workbook even when it is already opened in Excel. Despite using load_workbook(filename=filename, read ...
I have a spreadsheet formatted like this: A B C D yesterday 70 today 70 yesterday 71 today 71 My objective is to compare the data for today and yesterday with matching IDs (70 and 71 in this instance) separated by blank rows indicating different ...
I've encountered an issue while attempting to call a function from within a FOR loop. The error message I receive is: test() NameError: name 'test' is not defined Below is the code in question: from selenium import webdriver from selenium.common.excep ...
How can I retrieve a comprehensive list of all available sheet names from my Excel file using the ActiveX Object? I am aware that the code Excel.ActiveWorkBook.Sheets provides access to the sheets. However, how do I obtain an array containing the NAMES of ...
I am looking to combine 20 XML files into a single Excel file, with each XML file as an individual worksheet. Although the structure of the XML files is consistent, the values vary. You can see how the XML file appears here. Only the X and Y values are ...
Clicking on the "Export to Excel" button in this link will initiate a download of an Excel sheet containing detailed information about a specific stock. In my Excel VBA project, I need to automate the process of downloading this excel file. My code loops ...
Looking to update specific strings in a column within a data frame, which currently appears as: df["column"] ------------------ 1. Ne Road 2. Rosemarys street se 3. Plunkett pkwy 4. and so on..... There are thousands of values like these that nee ...
I am encountering an error in SeleniumVBA when trying to upload a file on an internal website. Can someone please assist me in resolving this issue? I am attempting to log in to a website and upload a file from a source to download some data. However, whe ...
Within my submission form, there are five distinct inputs that users can enter and submit. Currently, the entered data is being written to a .txt file successfully. Nevertheless, the objective is to organize and display the information in an easily readabl ...
My server is capable of generating excel files dynamically, and I am utilizing AJAX to download these dynamic excel files. Upon successful completion in the callback function, I receive the data for the excel file. $.ajax({ url: exporting. ...
Currently, I am developing a Microsoft Excel Add-in using React. My goal is to assign colors to specific cells based on the value in each cell, indicated by a color code (refer to the Board Color column in the image below). To achieve this, I retrieve the ...
I encountered an issue with the error message "Object doesn't support this property or method." Here is the code snippet that triggered the error: Dim webs, web As Object Set webs = driverg.findElementByCssSelector("*[class^='title-link id-trac ...
I encountered an error in the console while loading my application. I am new to angular and any help would be greatly appreciated. I am attempting to export the datatable into excel, and I believe the issue lies with this line: angular.module('myApp','dat ...
I am currently working on a project that involves tracking the order statuses of individual shipments from a list of URLs stored in an Excel sheet. The code I have written is capable of looping through the URLs and extracting information from them successf ...
I'm facing challenges with an API that provides natural gas data. The documentation for this API can be found at . It allows me to access Json-formatted data by inputting a URL into my internet browser. However, in order to download the Json data, I need t ...
My goal is to create a loop that attempts to click on an element until it is found. If this process exceeds a 15-second limit, a warning message will be displayed. The current issue is that the loop does not respect the 15-second limit and gets stuck in a ...
I am facing an issue where my code does not display any output when using isinstance. This problem is highlighted at the end of the code snippet. I attempted to input year 1 and tla_2=1, yet no output was generated. Could the issue lie with my isinstance s ...
I am facing an issue with my code where it is only writing the first value to Excel and not the rest. My goal is to read data from a webpage and write it to an Excel sheet. The current set of code I have works fine, but I need help figuring out how to run ...
Currently, my front end is built using Angular 4 and the back end is developed with Lumen 5.4. The task at hand requires me to export certain data as both an Excel and a zip file. I am utilizing the { saveAs } import from the package 'file-saver/Fil ...
I'm encountering a frustrating issue with my Selenium setup. Currently, I am using VBA along with Selenium to verify the presence of an element on a webpage. My approach involves locating the element and then checking its size. If the size is 0, it indic ...