SOLVED

excel online, copy and paste

%3CLINGO-SUB%20id%3D%22lingo-sub-3084288%22%20slang%3D%22es-ES%22%3Eexcel%20online%2C%20copy%20and%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3084288%22%20slang%3D%22es-ES%22%3E%3CP%3Egood%20day%20please%20can%20someone%20help%20me%2C%20I%20am%20using%20online%20excel%20script%2C%20I%20am%20trying%20to%20copy%20a%20range%20of%20cells%20in%20the%20following%20blank%20cells%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22captura1.PNG%22%20style%3D%22width%3A%20491px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343508i045BE7D7C235CAA1%2Fimage-dimensions%2F491x195%3Fv%3Dv2%22%20width%3D%22491%22%20height%3D%22195%22%20role%3D%22button%22%20title%3D%22captura1.PNG%22%20alt%3D%22capture1.%20PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20try%20to%20do%20it%20with%20a%20script%20since%20I%20have%20built%20a%20flow%20to%20carry%20out%20the%20process%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Captura2.PNG%22%20style%3D%22width%3A%20487px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343509i52F61B50AA9C9C4D%2Fimage-dimensions%2F487x185%3Fv%3Dv2%22%20width%3D%22487%22%20height%3D%22185%22%20role%3D%22button%22%20title%3D%22Captura2.PNG%22%20alt%3D%22Screenshot2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20help%2C%20I've%20been%20looking%20for%20information%20on%20how%20to%20do%20the%20process%20for%20a%20while%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3084288%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3085570%22%20slang%3D%22es-ES%22%3ERe%3A%20excel%20online%2C%20copy%20and%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3085570%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EHello%20friend%2C%20I%20already%20know%20the%20process%20that%20they%20show%2C%20it%20is%20not%20how%20to%20check%20if%20the%20cell%20is%20empty%20in%20script%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3085228%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20online%2C%20copy%20and%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3085228%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1290601%22%20target%3D%22_blank%22%3E%40andres164%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EMy%20knowledge%20of%20Office%20Script%20is%20very%20limited.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3ENevertheless%2C%20here%20is%20a%20link%20that%20might%20help%20you%20in%20your%20plans.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fdev%2Fscripts%2Fresources%2Fsamples%2Fexcel-samples%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EBasic%20scripts%20for%20Office%20Scripts%20in%20Excel%20on%20the%20web%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EIf%20you%20already%20know%20this%20link%2C%20please%20ignore%20it.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eadditional%20Link%3A%20%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FCopy-Excel-Data-with-formula-and-paste-only-values%2Ftd-p%2F710483%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20class%3D%22%22%3ECopy%20Excel%20Data%20with%20formula%20and%20paste%20only%20values%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3101553%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20online%2C%20copy%20and%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3101553%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1290601%22%20target%3D%22_blank%22%3E%40andres164%3C%2FA%3E%2C%26nbsp%3Bthis%20sample%20might%20likely%20be%20a%20helpful%20starting%20point%20(you%20should%20be%20able%20to%20modify%20it%20to%20only%20check%20the%20cells%20you%20care%20about)%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fdev%2Fscripts%2Fresources%2Fsamples%2Fcount-blank-rows%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECount%20blank%20rows%20on%20sheets%20-%20Office%20Scripts%20%7C%20Microsoft%20Docs%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3102591%22%20slang%3D%22es-ES%22%3ERe%3A%20excel%20online%2C%20copy%20and%20paste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3102591%22%20slang%3D%22es-ES%22%3Ehello%2C%20thank%20you%20very%20much%20thankspude%3CBR%20%2F%3E%20do%20it%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
New Contributor

good day please can someone help me, I am using online excel script, I am trying to copy a range of cells in the following blank cells

captura1.PNG

 I try to do it with a script since I have built a flow to carry out the process

Captura2.PNG

 

 

Thank you very much for your help, I've been looking for information on how to do the process for a while

 

 

4 Replies

@andres164 

My knowledge of Office Script is very limited.

Nevertheless, here is a link that might help you in your plans.

Basic scripts for Office Scripts in Excel on the web

If you already know this link, please ignore it.

additional Link: Copy Excel Data with formula and paste only values

 

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)

@NikolinoDE 

 


Hello friend, I already know the process that they show, it is not how to check if the cell is empty in script

best response confirmed by andres164 (New Contributor)
Solution

Hi @andres164, this sample might likely be a helpful starting point (you should be able to modify it to only check the cells you care about): Count blank rows on sheets - Office Scripts | Microsoft Docs

hola , muchas gracias thanks
pude realizarlo