Category "spreadsheet"

VBA stored procedure SQL Server

I'm trying to send data from excel spreadsheet to sql server. The code runs properly but the change of status is not done. Before those steps, I already added d

Get Cell Value From Another Sheet USING ADDRESS and MATCH

I have here a condition/function. I'm not really experienced in Google Sheets. =ADDRESS(MATCH(B32,Diana!B:B,0),1) Now, Diana is another worksheet. The result f

Is there any function in google sheets by which we can remove some numbers in google sheets?

Suppose there is a sheet in which there are 100 contact numbers and I want to bring the numbers in different google sheets after removing selected numbers. How

CAXLXS spreadsheet cells without colors when open with excell

I´m generate an spreadsheet with colors into cells, and when I a open the file with Open office or google spreadsheet works fine, but when with Excel the

Google Spreadsheet MAX + Join of other cells

I have a spreadsheet like this - I can't figure out how to dynamically search for this. I want to find the MAX Score Value + output the related name (no worries

Find and replace duplicate rows with the newest data in a defined range using Google Apps Script

Google sheet using columns A:M. Each day a new set of raw data (around 30 rows) is pasted on the next available row in column B manually. This raw data contains

PhpSpreadSheet: How to save Workbook sheets in individual CSV files

I'm using PhpSpreadSheet and I need to save the sheets contained in a workbook as individual CSV files. I've tried to use $reader->setLoadAllSheets(); but

Switch values and headers

I have a google sheet with a table card1 | card2 | card3 | card4 | card5 | card6 | card7 ------+-------+-------+-------+-------+-------+------ set3 | set1 |

Visual Studio C# Get sheet visible property

I'm trying to fill a dictionary with name as key, and an array with codename and if sheet is visible. This is where I ran into a conversion issue with sheet.vis

how to combine many google sheets in one sheet by using query

I created two online sheets and tried to collect them in another one sheet by query but there a missing data although it's exists in the original sheets (data s