Most viewed questions in Others

0 votes
1 answer

VBA Excel: Draw line between cells based on cell value

In accordance with your description and with ...READ MORE

Feb 6, 2023 in Others by narikkadan
• 86,360 points
2,057 views
0 votes
1 answer

Pentaho excel input from multiple sheets to textfile

It's possible to use numerous Excel inputs ...READ MORE

Oct 20, 2022 in Others by narikkadan
• 86,360 points
2,055 views
0 votes
1 answer

How do I align a UserForm next to the active cell?

Answer to Q1 - Yes, it's correct. In ...READ MORE

Oct 27, 2022 in Others by narikkadan
• 86,360 points
2,054 views
0 votes
1 answer

mod_rewrite seo friendly url passed as parameter only works with prefix on url

RewriteEngine On RewriteRule ^content/get_content.php\?url\=seo-friendly-url$ /content/seo-friendly-url [L] try this code ...READ MORE

Feb 24, 2022 in Others by narikkadan
• 86,360 points
2,054 views
0 votes
1 answer

Excel VLOOKUP where the key is not in the first column

INDEX/MATCH will do it in any direction of ...READ MORE

Oct 20, 2022 in Others by narikkadan
• 86,360 points
2,043 views
0 votes
1 answer

How to change where an email is sent FROM in Excel VBA

Inside the 'with out mail, insert this ...READ MORE

Mar 30, 2023 in Others by narikkadan
• 86,360 points
2,039 views
0 votes
1 answer

Return blank cell only if referred cell is blank, but return aging if date is entered

Try this: =IF(ISBLANK(AC2),"",TODAY()-AC2) The TODAY  function automatically refreshes based ...READ MORE

Dec 17, 2022 in Others by narikkadan
• 86,360 points
2,039 views
0 votes
1 answer

AWS RDS MSSQL logs so many failed login attempts

Observing log files When you look at a ...READ MORE

Mar 25, 2022 in Others by Edureka
• 13,690 points
2,038 views
0 votes
1 answer

Export DataFrame timedelta column to timestamp Excel column

The reason that the column format isn't ...READ MORE

Feb 6, 2023 in Others by narikkadan
• 86,360 points
2,037 views
0 votes
1 answer

Blazor - ClosedXml - excel cannot open the file beacause the file format or extension is not valid

Changed the following code: function BlazorDownloadFile(filename, bytesBase64) { var ...READ MORE

Jan 20, 2023 in Others by narikkadan
• 86,360 points
2,035 views
0 votes
1 answer

Regular expression to match standard 10 digit phone number

 If you are also interested in matching ...READ MORE

Feb 22, 2022 in Others by Aditya
• 7,680 points
2,034 views
0 votes
1 answer

How to apply zoom animation for each element of a list in angular?

To create a sequential zoom-in and zoom-out ...READ MORE

Jul 30, 2019 in Others by Vardhan
• 13,130 points
2,034 views
0 votes
1 answer

Convert image (jpg, png, jpeg) to base64

Try this - it will perform the ...READ MORE

Sep 24, 2022 in Others by narikkadan
• 86,360 points
2,029 views
0 votes
1 answer

How to freeze the =today() function once data has been entered

Don't enter this formula: =TODAY() Instead use  Ctrl + ; This will put a "frozen" ...READ MORE

Dec 17, 2022 in Others by narikkadan
• 86,360 points
2,028 views
0 votes
1 answer

Protect excel sheet but allow data entry with form

Try this: Private Sub Workbook_Open() ...READ MORE

Sep 30, 2022 in Others by narikkadan
• 86,360 points
2,024 views
0 votes
2 answers

Prepare Document for SSIS

Hi@vnk, SQL Server Integration Service (SSIS) is a component ...READ MORE

Oct 14, 2020 in Others by MD
• 95,460 points
2,024 views
0 votes
1 answer

Merge and export Excel/Word/PDF to PDF

Use GroupDocs.Merger for .NET API to merge Word, Excel, ...READ MORE

Oct 3, 2022 in Others by narikkadan
• 86,360 points
2,023 views
0 votes
1 answer

How to include/ install any library in node.js application program?

Node.js is server side runtime environment that ...READ MORE

Jul 26, 2019 in Others by ArchanaNagur
• 2,360 points
2,023 views
0 votes
1 answer

Exporting HTML Table to Excel Extension Issues

In my application, I'm experiencing a similar ...READ MORE

Nov 14, 2022 in Others by narikkadan
• 86,360 points
2,022 views
0 votes
1 answer

How to change two different date format into single date format in excel

With data in A2, in B2 enter: =IF(ISNUMBER(A2),A2,DATE(LEFT(A2,4),MID(A2,6,2),RIGHT(A2,2))) and apply your format ...READ MORE

Dec 24, 2022 in Others by narikkadan
• 86,360 points
2,021 views
+1 vote
1 answer

Excel macro to make selected range absolute or relative reference?

Try  this: Sub ConverReferenceType() On ...READ MORE

Oct 23, 2022 in Others by narikkadan
• 86,360 points
2,020 views
0 votes
1 answer

Quadratic and cubic regression in Excel

You need to use an undocumented trick ...READ MORE

Oct 1, 2022 in Others by narikkadan
• 86,360 points
2,019 views
0 votes
1 answer

Xamarin iOS app displaying white blank screen on iPad after update to Xcode 11

Assuming you have your iPad Pro connected ...READ MORE

Nov 4, 2022 in Others by gaurav
• 23,580 points
2,013 views
0 votes
1 answer

Android Open External Storage directory for storing file

To get the internal SD card you ...READ MORE

Jun 9, 2022 in Others by nisha
• 2,210 points
2,013 views
0 votes
1 answer

Convert Excel to PDF issue with documents4j

MS Excel may not always be used ...READ MORE

Sep 26, 2022 in Others by narikkadan
• 86,360 points
2,012 views
0 votes
1 answer

How to create Toast in Flutter?

Hi@akhtar, You can use the toast plugin to ...READ MORE

Jul 27, 2020 in Others by MD
• 95,460 points
2,010 views
0 votes
1 answer

Laravel , Blade & React js add the meta tag for rendering on server side SEO

use septia laravel side rendering and add ...READ MORE

Feb 24, 2022 in Others by narikkadan
• 86,360 points
2,006 views
0 votes
1 answer

Android YouTube app Play Video Intent

The best way to run videos on ...READ MORE

Jun 6, 2022 in Others by nisha
• 2,210 points
2,000 views
0 votes
1 answer

AWS VPC CIDR in both 10.0.0.0/8 and 192.168.0.0/16 [closed]

The Amazon Virtual Private Cloud (Amazon VPC) ...READ MORE

Mar 21, 2022 in Others by gaurav
• 23,580 points
1,994 views
0 votes
1 answer

Convert a single png file to jpg in vba

Try this code: Sub ConveretPNGToJpg() ...READ MORE

Oct 16, 2022 in Others by narikkadan
• 86,360 points
1,992 views
0 votes
1 answer

My VBA Addin creates a custom ribbon tab, but should only be visible for intended workbooks

The RibRefresh sub's logic is overly convoluted ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,000 points
1,990 views
0 votes
0 answers

A Generic error occurred in GDI+ in Bitmap.Save method

I am trying to copy a thumbnail ...READ MORE

May 23, 2022 in Others by Kichu
• 19,040 points
1,989 views
0 votes
1 answer

Error 1046 No database Selected, how to resolve?

I can help you with this doubt ...READ MORE

Feb 23, 2022 in Others by Aditya
• 7,680 points
1,983 views
0 votes
1 answer

Change Data Source Range for ALL Pivot Tables that are Using a Particular Named Range Within Excel via VBA

Try this: Sub Tester() Dim ...READ MORE

Jan 7, 2023 in Others by narikkadan
• 86,360 points
1,982 views
0 votes
0 answers

What are the sizes of GDTR, LDTR, IDTR and TR registers?

I have searched a lot for this ...READ MORE

May 12, 2022 in Others by Kichu
• 19,040 points
1,980 views
0 votes
1 answer

Excel cannot open the file because the file format or file extension is not valid - PHP Maatwebsite

Try this: if (ob_get_length() == 0 ) { ...READ MORE

Dec 19, 2022 in Others by narikkadan
• 86,360 points
1,978 views
0 votes
1 answer

Add a shape to a specific cell in Excel

When you use SORT() or data->sort on ...READ MORE

Oct 24, 2022 in Others by narikkadan
• 86,360 points
1,978 views
0 votes
1 answer

ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client

The user and password are DEFINITELY incorrect ...READ MORE

Feb 22, 2022 in Others by Aditya
• 7,680 points
1,977 views
0 votes
1 answer

How to use Excel VLOOKUP function with words that begin with the letters AB

If you lookup "AB" in Excel, it ...READ MORE

Nov 24, 2022 in Others by narikkadan
• 86,360 points
1,976 views
0 votes
0 answers

How to find the username of the instance launched in amazon-ec2?

I m having trouble connecting to the ...READ MORE

Apr 4, 2022 in Others by Kichu
• 19,040 points
1,976 views
0 votes
1 answer

Is there a way to lock cells after editing an excel sheet that's on sharepoint?

The Excel Web version (which, based on ...READ MORE

Oct 3, 2022 in Others by narikkadan
• 86,360 points
1,975 views
0 votes
1 answer

Microsoft.Office.Interop.Excel for Office 2007

Each client must install the  2007 Microsoft ...READ MORE

Nov 5, 2022 in Others by narikkadan
• 86,360 points
1,973 views
0 votes
1 answer

adding meta keyword in wordpress using yoast seo plugin.

You can use Advance Custom Fields plugin ...READ MORE

Feb 28, 2022 in Others by narikkadan
• 86,360 points
1,966 views
0 votes
1 answer

Autofill Copy down up until next empty row- Excel VBA Macro

Row 1048576 will be returned by end(xldown) ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 86,360 points
1,957 views
0 votes
1 answer

Excel Drop down list using Apache POI

To set a default value, just setCellValue("first_item_value"); she ...READ MORE

Nov 11, 2022 in Others by narikkadan
• 86,360 points
1,955 views
0 votes
1 answer

open link of google play store in mobile version android

You can use Android Intents library for opening your ...READ MORE

Jun 9, 2022 in Others by nisha
• 2,210 points
1,955 views
0 votes
1 answer

Avoiding memory leaks in C++

If you use smart pointers at all ...READ MORE

Nov 5, 2018 in Others by nirvana
• 3,090 points
1,953 views
0 votes
1 answer

Is there a color code for transparent in HTML?

There is no Transparent color code, but ...READ MORE

Feb 11, 2022 in Others by Soham
• 9,730 points
1,951 views
0 votes
0 answers

504 Gateway Timeout - Two EC2 instances with load balancer

The problem: I have Amazon EC2 running an ...READ MORE

Apr 4, 2022 in Others by Kichu
• 19,040 points
1,947 views
0 votes
1 answer

Output python dataframe to excel and create a new data_validation column in the exported excel sheet

Use pandas.ExcelWriter with worksheet.data_validation from xlswriter : df["code"] = None items = list(range(1,10)) max_row, max_col = ...READ MORE

Jan 24, 2023 in Others by narikkadan
• 86,360 points
1,946 views