excel Questions
2
Solved
I have a table I made in excel and I want to have the same table in my Azure DataStudio, how can I copy the data over? Thanks!
Amadoamador asked 6/5, 2020 at 17:54
7
Solved
Having a frustrating time with scheduling a Python script (C:\Python27\test.py), which has the following code:
import xlrd
import csv
with xlrd.open_workbook('Z:/somefile.xls') as wb:
sh = wb.she...
Harmon asked 2/4, 2014 at 18:47
11
Solved
What function can I use in Excel VBA to slice an array?
Goldston asked 6/10, 2008 at 16:54
4
Solved
I have a button that should be clickable in excel. When I try to click it, nothing happens. I have noticed that if I click and hold the mouse in the lower right hand corner, a second button appears...
6
I'm trying to read data from an Excel sheet that contains merged cells.
When reading merged cells with openpyxl the first merged cell contain the value and the rest of the cells are empty.
I would ...
10
This is my code, and I found many answers for VBA, .NET framework and is pretty strange. When I execute this, Excel closes.
from win32com.client import DispatchEx
excel = DispatchEx('Excel.Applica...
5
Solved
With data in A1 - B5:
A 1 //remove
A 2
B 3 //remove
B 2
C 1
How do you remove duplicates in column A, keeping the last set of values in other columns? Results should look like this:
A 2
B 2
C 1
I...
Flighty asked 25/4 at 20:14
6
Solved
I'm designing a set of related excel file which are related between them. The objective is that the macros which refere to each other document, can work in any given computer/path. For this reason ...
Unclothe asked 25/7, 2019 at 9:29
3
Solved
I am currently trying to figure out how to select a range from the second row to the last row, but more specifically between a range of columns. For instance I want to select Range(A2:L2) to the la...
3
I'm working with a set of data which has almost 60 columns (Text/Address/Numbers). After processing the data using Pandas, I have to export it to xlsx format.
This is how I'm generating the output:...
12
I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package The Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System.Data)
...
Oruntha asked 1/11, 2016 at 13:20
15
Solved
I need a function to add a GUID to cells in excel. I found this previous question on stackoverflow, but it is not working. It suggests the following function:
=CONCATENATE(DEC2HEX(RANDBETWEEN(0,429...
3
Solved
I have an Excel macro in VBA. Yesterday everything worked fine, this morning VBA is changing a decimal point to a comma. That is from 5.1 to 5,1.
I am using a German system and have set in Excel's ...
Morphogenesis asked 9/5, 2017 at 7:16
17
Solved
I have a HTML table in velocity template. I want to export the html table data to excel using either java script or jquery, comatibale with all browser.
I am using below script
<script type="...
Raffaello asked 11/3, 2014 at 6:22
12
Solved
I'm currently using pandas to read an Excel file and present its sheet names to the user, so he can select which sheet he would like to use. The problem is that the files are really big (70 columns...
7
Solved
I'm generating an Excel workbook using OpenXml and have been following the examples at http://msdn.microsoft.com/en-us/library/cc850837.aspx
It would be really useful if I could freeze the top pan...
39
Solved
I'm trying to get data from an Excel file on a button click event. My connection string is:
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-D...
8
I have an Excel file which includes pictures in column B and I want like to export them into several files as .jpg (or any other picture file format). The name of the file should be generated from ...
8
I must to autosize column width with exceljs.
My excel must be dynamic and save in Excel only the columns that the user will provide in the request. To this case I provide this syntax:
workSheet.ge...
Cupriferous asked 31/7, 2020 at 10:3
4
Solved
I am trying to get the Date as a string formatted yyyy-mm-dd.
I have tried various things with strange results:
Dim mydate As String
mydate = Date
mydate = Year(Date)
mydate = Month(Date)
mydate ...
3
Allow Groups to Expand/Collapse While Spreadsheet Is Password Protected. Even after closing the file
While protecting formulas with standard code like this:
Sub TestMe
dim myCell as range
with Worksheets(1)
For Each myCell In .Range("A1:R102").Cells
If myCell.MergeArea.Cells.Count ...
Thorncombe asked 22/1, 2021 at 15:5
3
Solved
I have some data in an Excel Worksheet. I would like to select all the cells which contain data.
For example, for a worksheet with data in cells A1, A2, A3, B1, B2, B3, C1, C2, and C3, how can I s...
7
Solved
I need an easy way to set border around multiple cells, like so:
All I found was border of 1 cell, and merge cells, which is not what I need.
I was expecting for something like:
worksheet.range...
Cumber asked 6/2, 2014 at 10:13
11
How do you convert multiple xlsx files to csv files with a batch script?
Arlberg asked 10/3, 2011 at 7:34
3
Solved
I tried char(10) and char(13) but they don`t work by me. I use Excel 2007 and my task is to replace new lines with intervals
Asdic asked 18/12, 2015 at 16:11
© 2022 - 2024 — McMap. All rights reserved.