Newest excel Questions

Q&A for professional and enthusiast programmers

tMongoDBbulkLoad is not available to download in talend exchange

I have 10 lakh data and I have to transfer it from excel to mongodb and It is throwing heapspace error.So How can I perform this job in Talend tool.I have searched for tMongoDBbulkload and it is not ...

Removing duplicates within formulas

Is it possible to remove duplicate value in column with a formula in it? I would like to remove all the duplicates from columns C and D. Code in column C: =IFERROR(INDEX(Sheet2!$A$2:$A$200;AGGREGATE(...

Auto Generate Number Microsoft Excel

how to generate auto number from 0,000000000000000000000000000001 till 0,999999999999999999999999999999 at excel and the format cell is number ? i've tried for dragging mouse , but i guess thats so ...

Golang excel plugin that can change font color and import picture files

I am developing a golang project, and I am using Luxurioust/excelize plugin for excel file output because I need its AddPicture function. But I can't seem to change the font color with the plugin. Is ...

Best API to read/write EXCEL documents with spring mvc

I am developing a web application with spring-mvc, hibernate and MySQL. I need to : export data from Database table to an EXCEL document. import an excel file , read data, and insert this data in my ...

Adjusting cells width and height in excel in mm/cm through python script

I tried to look for it but couldn't find one. Is there a possibility to adjust the width,height of cells in excel in mm or cm dimensions using openpyxl or xlwt modules? if yes then can someone point ...

How to concatenate strings in array using for loop in excel vba

I am currently trying to iterate through rows in an excel sheet and concatenate the columns with some other hard coded data. Right now I am doing it the manual way as I do not know how to concatenate ...

How to download the content of a JqGrid as Excel (with style)?

does anyone know a way to download the content of a JqGrid into an excel file with all the style properties for the cells? Basically I want to make it possible to download the Grid into Excel with ...

I want to copy Data from Excel without using Interop.Excel in C#? [duplicate]

I want to copy Excel data might be single row or multiple rows but don't want to use Microsoft.Office.Interop.Excel since server where I run the code does not have microsoft office installed. Copied ...

Excel cells show 0 instead of blank

I've been working on some formulas and in cells instead of blank it shows 0. Code looks like this =IF(ISNUMBER(MATCH(A2;B$2:B$100;0));"";A2). I have tried IFERROR and it set to general.

How to loop function through list of aurguments in VBA

I am looking to make this VBA function more dynamic and handle a list of inputs rather than a single static argument. The function I have is working correctly for a single hard coded file, I would ...

Get Word bookmark index to replace image inside bookmark from Excel

This question is related with a previous one. I have an open Word document with a bunch of bookmarks, each with an inline image of an Excel table previously exported from Excel. Now, I need to ...

Late binding UDFs for access across workbooks

I made a UDF in excel which I want to access from all of my excel projects. To do this I put it in a module of PERSONAL.XLSB and invoke with =PERSONAL.XLSB!MYFUNC(Arg1, Arg2...) However I get the ...

append cell row to matrix

I'm reading an excelfile in matlab with [NUM,TXT,RAW]=xlsread(DATENEXCEL,sSheet_Data); In the excelfile are different datamatrices in different sheets in the following form Date Firm1 Firm2 ...

How can I connect Microsoft Excel (via PowerPivot) to my XAMPP Based SQL Database?

This is an odd one, works perfectly well on my home PC (desktop) where both Microsoft SQL Server 2016 and XAMPP are installed. I simply have to stop all the MSSQL services and then (through "Use ...

Extract substring from this string inside Excel cell

I have this Excel cell A2 with the contents USD.EUR[IDEALPRO,CASH,EUR]. I would like to extract the substring EUR from the last part of the string using an Excel formula. The nearest formula I came ...

Change Excel new line character

I have a file that looks like this: ------------ comment1 ------------ comment2 part 1 comment2 part 2 ------------ comment3 I'd like to import this file in Excel. By default, Excel treats new lines ...

I want to calculate the EMI on ammortisation in VBA before recording it to worksheet

"I want to calculate EMI befor posting the same to Excel worksheet, Wants to include prepayment and payment details also. if anyone having the same kind of format, sharing will be the best possible ...

VBA: Determine whether cell value is below average in range (multiple ranges)

What I am trying to accomplish is the following: I want each cell in a range (examples below) to be checked whether or not it is lower than the average of the range. If the value of that cell is lower ...

Vlookup all the values matching the search term instead of just one.

So the following formula returns only the first value from the range. I kinda need all the matching search results indexed instead of just 1. =Vlookup("*" & B3 & "*",A:A,1,0) SPREADSHEET ...

How to merge Sheets from different Excel in a Master Excel using a button / Macro

I want to know if there is a good approach to merge a single sheet from different Excel workbooks in a master Excel? The structure looks like below: I have 1 Folder with the Master Excel, and within ...

Check cell values in two different sheets

I have two sheets in an excel file namely bank_form and Pay_slip. I am trying to write a vba to check whether value/text in cell B5 of sheet Pay_slip is equal to value/text in cell B8 of sheet ...

Excel saving to My Documents and not file location [on hold]

My Excel keeps saving to My Documents and not file location located on the shared drive. The file is a shared document with macros. Can anyone help me please? Not sure why its defaulting to my ...

Open Multiple Excel Files in separate intances with Batch File

I run multiple excel instances / files which require a manual PC restart daily. Currently I save all my excels, restart the PC, then have to open each file separately which is quite manual. Is anyone ...

VBscript to save excel sheet as pdf

<html><head> <script language="vbscript" type="text/vbscript"> Sub SaveExcelAsPDF () 'Save Excel file as a PDF 'Initialise Dim objExcel, objWorkbook Set objExcel = CreateObject("...

Select Outlook Folder With Excel VBA

I'm trying to bypass having to select the folder I want and just tell Excel to go ahead and count the "Inbox" Sub Get_Emails() Dim OLF As Outlook.MAPIFolder Dim EmailItemCount As Long Set OLF = ...

How to filter export data based on value-matching in another sheet and AND OR filters

I have Sheet1 Sheet2. EG, in Sheet1 I have |Column A|Column B|Column C|Column D|Column E|Column F|Column G| |1001 |Step 1 |ID1 |--- |--- |--- |--- | |1002 |Step 2 |ID2 ...

HOW TO: FIX ERROR - “the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine”

While uploading excel this issue is raising. I set Application pool 32 bit false and it works fine. After two weeks it again raising the same issue.

How to create if condition to create excel sheets

I am trying to create a VBE Code to create a new excel worksheet. To create a new worksheet I am using the code below and is working really fine: Dim ws As Worksheet With ThisWorkbook ...

VBA - looping though only selected sheets to proceed several steps

I have an Excel file which contains several sheets where I have to cut-copy from one column to another. When I use the code on one specific sheet it works perfectly, yet while I've already tried to ...

Replace image inside Word bookmark from Excel

I have an open Word document with a bunch of bookmarks, each with an inline image of an Excel table previously exported from Excel. Now, I need to update the tables in the Word document as they have ...

Color cells based on value in another sheet. Corresponding name, and date

I want all cells in columm B to be either Red or Green, based on values in another worksheet. I have attached a mockup of what I would like. In this worksheet, I would like the "STATUS" cells to ...

PHP & MySQL to Excel

As title already specifies I need to send data from MySQL to excel via PHP with some filtering i.e. value greater than 0. I have fond this code which works great... <?php /*******EDIT LINES 3-8**...

How to saveas a specific worksheet in a workbook with multiples worksheets

I have one workbook with multiples worksheets and multiples macros assigned to buttons. Well, one of these buttons is responsible to create a new worksheet named "Savings" and saveas this worksheet ...

SSRS mail subscription XLSX issue

I have setup a SSRS mail subscription which generates XLSX format report and sends it via Clearswift Mimesweeper to clients. But the XLSX files generated in this method is getting quarantined in ...

Left vlookup error

I am trying to do left vlookup here. I understand that I have some values that cannot be found but I don't understand why is there still error of Application-defined or object defined error popping ...

Issue in implementing GAMMA.INV function

While trying to implement the GAMMA.INV(probability, alpha, beta) of MS Excel in C#, there are some problems in my implementation when the alpha and beta parameters are greater than 1. please find the ...

Assistance with excel-VBA macro - beginner

I have an excel spreadsheet I must perform lots of formatting on, on a weekly bases. I've decided to try create a VBA macro for this in order to quicken the process. I have around 8 different steps ...

Insert Specified Number of Rows on Specified Date Column Change

Before you flag this, please note that I need to amend Existing code to be able to fit multiple cases. I have: Sub InsertRowAtChangeInValue() Dim lRow As Long For lRow = Cells(Cells.Rows....

Freeze column content from drop down in Excel

Hi I am new to excel for this kinds requirements. I want to freeze the cell content (from a drop down) once a selection is made. Users should not be able to modify the entered content. Once the ...

data manipulation in Excel: search row backwards and extract only non-repeated data

I have a dataset of herbicide applications and the dates they were applied. For example, the raw dataset looks like this, where 'h1' is herbicide 1, and 'd1' is the application date for herbicide 1, ...

Copy & Paste Only Cells With Data While Keeping Row Spacing

I've highlighted a column & I can select only the cells with text by using Go To & selecting constants. I'm trying to paste into an existing column in within the same row, but when I paste, it ...

Checking PC Date region in Excel/VBA

Is there any VBA function that lets me check a PC date format (regional setting). This is set within the Control Panel -> Region and Language. Michael

Excel VBA - Correct VBA code for summing multiple rows

What is the correct way to code in VBA the below formula? I need to sum 5 columns in a row in the 6th column, and do this for a total of 7 rows. Range("G21").Select ActiveCell.FormulaR1C1 = "=SUM(RC[...

VBA Excel copying and pasting a Template

Background story: I'm doing a little project that is for my little association to help people to have a clear and understandable accounting system. I'm a total novice in VBA and I have been looking ...

How can i Store java console output to Cloud database

I am new to java, in fact, this is my first java application! I have developed a client and i am using simulation server to check my client application.As my client can read, write and browse the data'...

kendo UI Export data and image to excel file

<script> function exportExcelChart(tagName) { var tagObjList = [] var reportWrapperID; var filters = Trend.Chart.Filters, tagModels = Trend.Chart._getTagModels(); ...

How to export around 50000 rows from excel to mysql db

I have around 50000 records in an excel spreadsheet and i want to export it to mysql db. What is the best way to do it. I used MySql for Excel but the desktop is hanging. I even came across this ...

I need to export sql server results to new excel work book?

I need results into a new workbook, at present am getting the results in existing workbook? Sub ConnectSqlServer() Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Dim sConnString As String ...

How to only add rows to table which don't exist MSaccess

My first post/question here, I have searched and tried many options but nothing seems to fit exactly what I need. I am building an Access DB to manage scheduling work and assigning employees to that ...
Translating... 0%